IF Formula

[tanyaleblanc]

Hi, just trying to create an IF formula, I want to say ' if R3 = M, V3 is 2.5, R3 = Q, V3 is 7.5, R3=S, V3 is 15 and R3 = A, V3 is 30

How do I put this in an IF formula

=IF(R3=M, V3, "2.5", R3=Q, V3, "7.5", R3=S, V3, "15", R3=A, V3, "30")

 

[sandy666]

try in V3

=CHOOSE(MATCH(R3,{"M","Q","S","A"},0),2.5,7.5,15,30)

 

[tanyaleblanc]

works perfect, never even heard of this formula before, thanks so much!!!

 

[sandy666]

You are welcome

Have a nice day