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
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
I am playing all the right notes, but not necessarily in the right order.
Eric Morecambe
An OR statement?
=IF(OR(D5=0,B5=0),0,(B5-D5))
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
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
I am playing all the right notes, but not necessarily in the right order.
Eric Morecambe
We'll let it go this time!Originally Posted by Hoopsah
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'