Please Explain in Lamen's Terms

[Guest]

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

 

[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

 

[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)

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.