Multiple criteria for if statement

[Meucci98]

Could someone please help.

I have multiple criteria that I need to check and give different answers for, it goes something like this:

If C21 = A, then L8 = C30 x 1
If C21 = B, then L8 = C30 x 2
If C21 = C, then L8 = C30 x 3
If C21 = D, then L8 = C30 x 4
If C21 = E, then L8 = C30 x 5

 

[Caribeiro77]

Welcome to the forum..

Ok just try: in cell L8
=IF(C21="A",C30*1,IF(C21="B",C30*2,IF(C21="C",C30*3,IF(C21="D,C30*4,IF(C21="E",C30*5)))))