I need to create a formula that has an IF condition and an AND condition.
This is what I would ultimately like: =IF(AND(B4>8,B4-8,C4="")B4>8,B4-8,0)
It needs to look at cell B4 figure out if it is greater than 8 then subtract
8 from B4 but only if it cell C4 is blank. If C4 is not blank it needs leave
the value from cell B4 alone.
Can you help?
Thanks!
Bookmarks