Please Explain in Lamen's Terms

K

Karen

Would someone please explain the following formula in lamen's terms?
Specifically, what does the "1" and "0" mean?

=IF(A25-"x",1/$A$50,0)

Thank you
 
R

Ron de Bruin

Hi Karin

=IF(logical_test,value_if_true,value_if_false)

If A25 = x then do this 1/$A$50 (1 divide thru a50)

If not display a 0
 
H

Harlan Grove

Karen wrote...
Would someone please explain the following formula in lamen's terms?
Specifically, what does the "1" and "0" mean?

=IF(A25-"x",1/$A$50,0)
Click to expand...

What do 1 and 0 usually mean? They're numbers.

The IF formula you show will always return the #VALUE! error because no
matter what's in cell A25, A25-"x" is meaningless. As for the second
term in the IF function, / is the symbol used for division, like + is
used for addition, - for subtraction, and * for multiplication.

If you mean what are the 1 (or 1/$A$50) and 0 terms themselves, read
about the IF function in online help.
 
Top