Hi,
I spent a fair amount of time yesterday to get this to work without success.
I tried with nested IF functions but got the same outcome.
Here is what I want to happen:
Cell C4 (formatted general) can have 3 different content: 1. blank, 2. the word "sell", 3. the word "buy".
The results in cell P4 (formatted currency) should be:
1. When C4 = blank, P4 = blank (not $0.00)
2. When C4 = "sell", P4 = blank (not $0.00)
3. When C4 = "buy", P4 = SUM(L4:O4)
This is what I finished up with:
=IF(OR(C4="",C4="sell"),"",SUM(L4:O4))
I get the right result only if C4 = "buy", both other times I always get #VALUE!
Can someone please tell me where the bug is.
Thanks in advance,
George
Bookmarks