K
Karen
Would someone please tell me what the "1" and the "0" mean in this function?
=IF(A25="x",1/$A$50,0)
Thank you
=IF(A25="x",1/$A$50,0)
Thank you
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
=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
J
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")
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")
L
lewscannon
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.
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.
B
bj
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
equal 1 divided by the value in cell A50, if A25 does not have an "x" in it
the value will be 0