Forum Discussion
Multiple IF conditions
I am trying to get multiple IF condition based on below matrix but unable to get through: Stage Weightage Revises 0.6 M1 0.6 BPA 0.16 M1 0.16 If for example cell B2 in ...
But if B2 contains M1, should C2 return 0.6 or 0.16?
HansVogelaar I realized after posting there was a duplicate entry. M1 value is 0.6.
With a small lookup table:
The formula in C2 is =VLOOKUP(B2,$E$2:$F$4,2,FALSE)
This can be filled down.
Without a lookup table:
=IF(OR(B2={"Revises","M1"}),0.6,IF(B2="BPA",0.16,""))