Please Explain Formula

[Guest]

Would someone please tell me what the "1" and the "0" mean in this function?
=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

 

[JE McGimpsey]

If the conditional (A25="x") is true, then 1/$A$50 will be returned by
the function (so if $A$50 = 5, the result will be 1/5 or 0.2). If the
conditional is false, 0 will be returned.

Since XL treats TRUE/FALSE as 1/0 in calculations, the IF statement is
functionally equivalent to

= 1/$A$50 * (A25="x")

 

[Guest]

This is an if statement. If the contents of cell A25 = x, the "1" is being
divided by the contents of cell A50, and the results are returned to whatever
cell contains this formula. If the contents of cell A25 are anything else
than "x", a "0" is returned to that cell.

 

[Guest]

in this formula if cell A25 has an "x" in it the cell iwth the equation will
equal 1 divided by the value in cell A50, if A25 does not have an "x" in it
the value will be 0