Multiple IF conditions

Copper Contributor

I am trying to get multiple IF condition based on below matrix but unable to get through:

 

StageWeightage
Revises0.6
M10.6
BPA0.16
M10.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

@Dilip1615 

But if B2 contains M1, should C2 return 0.6 or 0.16?

@Hans Vogelaar  I realized after posting there was a duplicate entry. M1 value is 0.6. 

@Dilip1615 

With a small lookup table:

S2339.png

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,""))