Would someone please tell me what the "1" and the "0" mean in this function?
=IF(A25="x",1/$A$50,0)
Thank you
Would someone please tell me what the "1" and the "0" mean in this function?
=IF(A25="x",1/$A$50,0)
Thank you
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
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Karen" <[email protected]> wrote in message news:[email protected]...
> 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 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")
In article <[email protected]>,
"Karen" <[email protected]> wrote:
> Would someone please tell me what the "1" and the "0" mean in this function?
> =IF(A25="x",1/$A$50,0)
>
> Thank you
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.
"Karen" wrote:
> Would someone please tell me what the "1" and the "0" mean in this function?
> =IF(A25="x",1/$A$50,0)
>
> Thank you
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
"Karen" wrote:
> Would someone please tell me what the "1" and the "0" mean in this function?
> =IF(A25="x",1/$A$50,0)
>
> Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks