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
Printable View
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
An OR statement?
=IF(OR(D5=0,B5=0),0,(B5-D5))
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
We'll let it go this time!:devil2:Quote:
Originally Posted by Hoopsah