I have a spreadsheet where if a date appears in one cell (L6) then I want to subtract I6 from H6, but if no date appears I want to just display H6 value in Q6. But if L6 and N6 have a value, but P6 doesn't then I want Q6 to equal H6-I6-M6. If L6 and N6 and P6 all have values I want Q6 to equal H6-I6-M6-O6.
I had previously posted and kindly received the following formula which works, but I wanted to add one more condition and can’t seem to work it out myself.
The formula I was given is:
=IF(L6="", H6, IF(N6<>"", H6-I6-M6, H6-I6))