Please see attachment: I was trying to do an IF function in column H where if there is a value in columns F or G >0 then it would return a 0. But if there is no value then return column E. In my attachment I have tried doing it, but it always returns #Value. I'm not sure if there is a way since it would be performing 2 different logic tests trying to return 2 different values in column H.
EX: If I put a date in any column F or G then I want column H to show 0, but if there is no date in column F or G then I want column H to show amount in column E, in the attachment it would be $535.
Bookmarks