Hi Guys,
I am trying to add an extra IF statement, so probably need a nested IF? I have done the first part (please see attached) but need to know how to add an extra element.
Breakdown
I have a Total cell (D6) that calculates 2 cells (B1 & B2) but only A1 = "ON". If A1 is not "ON" then "not applicable" is shown.
I now need the total (D6) to also show "not applicable" if B1&B2 bring back a value equal to or lower than 4 (A1 must also be "ON")
confusing, but I hope I explained it...please see attachment.
Thanks!
Bookmarks