Forum Discussion
Solved
IF OR NEST ERROR
Hi, My nested IF OR statement isn't working and I can't work out why. Basically column K either has Unfit or Part SAT, and column L has Available or Constraint, and when changed to different combos ...
You need to use AND instead of OR, as far as I can tell.
You need to use AND instead of OR, as far as I can tell.
That was my conclusion as well.
The formula is a bit shorter with a nested IF within each branch of the first condition
= D9 * IF(K9="Part SAT", IF(L9="Constraint", 2, 1), IF(L9="Constraint", 3, 2) )or, then again, one could dispense with the IFs and use
= D9 * (1 + (K9="Unfit") + (L9="Constraint"))
