IF Multiple citeria.

[srizki]

Hi everyone and happy new year.
I need to formula, that is Quantity * % of rate per unit. % depends conditions. A, B, C or D.
A=100%, B=75%, C=50% and D=25%
I or user will input quantity and price per unit and the formula will calculate the total price.
I want the formula in cell let’s say, C4, see the condition dropdown (A, B, C or D) in cell B4 and populate the % accordingly.
Just to explain better, it is something like,
=IF((B4=”A”, 100), IF(B4=”B”,.75),IF(B4=”C”,.5),.25))
Or =choose(…
And of course the above formula is wrong.

Thanks

 

[Joe4]

One way:

=IF(A4="A",100%,IF(A4="B",75%,IF(A4="C",50%,IF(A4="D",25%,""))))

Note that 100% does NOT equal 100. It actually equals 1.

 

[srizki]

Thank you Joe4

 

[Joe4]

You are welcome.