Hi. I was hoping you could help me. This question has multiple layers. 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.
I have used this formula and it works: =IF(ISBLANK(L6), H6, H6-I6)
But if H6 has a value, but N6 doesn't then I want to H6-I6-M6.
This formula also works: =IF(ISBLANK(N6),H6-I6,H6-I6-M6)
But I actually want to merge the formulas together, so if both cells are blank, then Q6 shows the H6 value, but if L6 has a value but N6 doesn't then I want Q6 to subtract I6 from H6, but if both L6 and N6 have a value, then in Q6 I want the answer to the equation H6-I6-M6.
Hope that makes sense.
Many thanks
I have used this formula and it works: =IF(ISBLANK(L6), H6, H6-I6)
But if H6 has a value, but N6 doesn't then I want to H6-I6-M6.
This formula also works: =IF(ISBLANK(N6),H6-I6,H6-I6-M6)
But I actually want to merge the formulas together, so if both cells are blank, then Q6 shows the H6 value, but if L6 has a value but N6 doesn't then I want Q6 to subtract I6 from H6, but if both L6 and N6 have a value, then in Q6 I want the answer to the equation H6-I6-M6.
Hope that makes sense.
Many thanks