the if function uses 3 parameters:
1) boolean (i.e. either true or false) variable or expression
2) variable to use if the boolean value is true
3) variable to use if the boolean value is false
for example in the following expression
if(x>3,x+3,x-3)
if x > 3, then the function returns x+3, otherwise it returns x-3
if x = 0, since 0>3 is false, then the function returns x-3 which would be -3
if x = 4, since 4>3 is true, then the function returns x+3 which would be 7
2006-06-30 18:31:03
·
answer #1
·
answered by Rambo Smurf 4
·
0⤊
0⤋
I am not sure if you are talking about using the IF statement in excel or just a general logic statement, but here you go...
In excel you have =IF(logical_statement, result_true, result_false)
For example, =IF(a3-a2>0, "Refund", "You owe")
In the example, if the results of cell a3 minus cell a2 is greater than 0 the output would be the word Refund. If the results of cell a3 minus cell a2 were equal to or less than 0 then the output would be You owe.
Hope this helps.
2006-06-30 18:39:23
·
answer #2
·
answered by Mike B 3
·
0⤊
0⤋
Just plug in your values for the variables in the formula and work it out!
2006-06-30 18:32:08
·
answer #3
·
answered by ♥Tom♥ 6
·
0⤊
0⤋