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 excel has Stage as Revises, my requirement is for IF condition in cell C2 to return value 0.6; likewise if M1, BPA - the related values listed should reflect in C#. The values are static and thus can be defined in formula itself.
3 Replies
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,""))
