Assuming that I have a worksheet with columns A,B,C and D on it, I want an IF statement in column E which follows this argument:
IF A1 is "0" or "N/A", then show N/A, but if A1 is any other number, then B*(C+D)
I hope that's easy to follow. I have tried so hard to get this to work but just can't.
As ever, any help would be hugely appreciated.
Thank you
Bookmarks