Using If statments and Data Validation

[LanceDracofire]

I am trying to create a formula consisting of if statements based on a data validation box. The formula im trying is

=IF(a1="Medium",i9*0.03,=if(a1="High",i9*0.7,=if(a1="Low",i9*0.01,0)))

A1 is in a table with a dropdown box to limit to High,Medium,and Low.im also adding similar if statments to this so it adds it all up in b2

 

[SeaDragon]

Don't use the "=" signs in front of functions that are inside your formula.

=IF(A1="Medium",I9*0.03,IF(A1="High",I9*0.7,IF(A1="Low",I9*0.01,0)))

If those multipliers will ever need to be tweaked or changed in the future, it may be wise to set them up in named ranges and reference those.

 

[LanceDracofire]

The = sigh is part of the logical test like im saying if A1 says (equals) medium than.....

 

[LanceDracofire]

Oh wait...nevermind thank you but it still wont work if I take those out

 

[SeaDragon]

Oh wait...nevermind thank you but it still wont work if I take those out

The formula I posted works correctly.