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 <!-- / message -->

 

[VoG]

That formula works for me.

 

[JamesW]

Hi there,

What is the problem you are experiencing? This formula should work fine.

 

[LanceDracofire]

Im using a table and it just comes up as an N/A

Here is the whole thing

=IF(a1="Medium",i9*0.03,IF(a1="High",i9*0.7,IF(a1="Low",i9*0.01,0)))+(if(c1="Medium",i9*0.03,IF(c1="High",i9*0.7,IF(c1="Low",i9*0.01,0))))+(if(d1="Early",i9*0.03,IF(d1="Mid",i9*0.7,IF(d1="Recent",i9*0.01,0)))))