How can a logical test equal one cell?

[Mtyler]

I'm confused.

I'm reviewing someone else's work and they have used the following if formula

=+IF(D15,D15/E15-1,"")

Cell D15 does not contain anything other than a hard coded number.

Surely this if function is useless, even if D15 contains nothing?

Thanks

Matt

 

[Jonmo1]

In the formula posted at the top of the thread, the logic is "If D15's got something in it, divide it by E15 and then take away 1". In that formula, E15 would be the one causing the DIV/0 error, so why test D15?

Who knows, the OP didn't write it. Maybe the person who wrote it has some other logic for why they would do that...Honestly, it doesn't make sense to devide if EITHER number = 0. But the Div/0 error is only caused by the # to the right.

I was just giving an example of Why =IF(A1,true,false) is usefull...