IF FORMULA IN EXCEL

The description of IF formula in Excel


The formula of IF function in excel write as IF (logical_test, value_if, value_if_false)
On this column should be fill only tree component, logical_test is any value or expression that can be evaluate as True or False.

For example A10 = 100 this mean that at column A10 on excell have value 100 the expression evaluate as True. Otherwise the evaluation result is False. This only comparison the real value and compare to value at column A10.

Value_if_true its mean that if the value at A10 is True then the logical_test is true. Value if_true can be fill by text string or word such as “Within Budget”, the word “Within Budget” will merge if logical_test argument evaluates as True. But if the value of logical_test is True and value_if_true is blank, this argument will result 0 (zer0).

Value_if _false is other option if the logical_test is False. For example, the result of value_if_false fill by text still for example “Over Budget” this will merge if on the logical_test value is false or wrong. If this value let it blank then (before parenthesis is blank) then the value will get 0 (zero).

Formula if is applied in each cell where you want to use this logical that refer to another cell.
Understood? If still doubt see the picture below:

Formula IF

I write the formula in column C5, the statement says that if the value in column B5 more or similar with 1000 so column in C5 will merge OVER BUDGED, but if I fill column B5 less than 1000 then in column C5 will merge OK. If the formula on the formula bar I write like this =IF(B5>=1000;"Over Budget"), this mean that value_if_false let it blank and the result will 0 (zero) if I fill in column B5 less than 1000.

Comments

Popular posts from this blog

Ball Volume and surface Area

Mathematic Principle

Arithmetic