English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

2006-06-30 18:26:19 · 3 answers · asked by kpkmanda 1 in Education & Reference Homework Help

3 answers

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

fedest.com, questions and answers