PDA

View Full Version : If formula - Can't get to work properly



Hoopsah
04-23-2013, 05:38 AM
Hi

Looking for a bit of help with this formula,

Basically it should be:

If D5=0 then 0, else B5-D5, if B5 = 0 then 0 else B5 - D5

Sounds easy when I write it but I can't get it to work at all

Any help appreciated

mdmackillop
04-23-2013, 05:55 AM
An OR statement?
=IF(OR(D5=0,B5=0),0,(B5-D5))

Hoopsah
04-23-2013, 06:02 AM
Fantastic MD thank you.

*** Just realised that I have cross posted - not intentionally but each time I tried on here I was getting a message that the server was busy so I tried elsewhere ***

Please accdept my apologies and my thanks

mdmackillop
04-24-2013, 05:15 AM
Please accept my apologies and my thanks

We'll let it go this time!:devil2: