Nesting or And function?

[Utradeshow]

Hi All,

I have a tricky formula that I'm stumped on.

In cell A1 I have a dropdown that is taxable and non taxable
In cell B1 I have a dropdown with 3 counties Broward (6%), Dade (7%), Palm Beach (7%)
In cell C1 i have a sale amount and I am trying to calculate the tax rates with the result in cell D1.

If cell A1 says "Taxable" then the result in cell D1 would calculate based on the value of B1.

Thanks a Bunch!!

 

[Utradeshow]

So B3 can equal "REC 90 (Non Ethanol Gasoline)" or "Unleaded Gasoline"? If so, try the following modification:

=IF(OR(B3="REC 90 (Non Ethanol Gasoline)",B3="Unleaded Gasoline"),IF(B9="Service County - Dade",0.183,IF(OR(B9="Service County - Broward",B9="Service County - Palm Beach"),0.203,0)),IF(B3="Ultra Low Sulfer Diesel",IF(B9="Service County - Dade",0.153,IF(OR(B9="Service County - Broward",B9="Service County - Palm Beach"),0.153,0)),0))

Yes sir!! Thank you so much

 

[dreid1011]

Yes sir!! Thank you so much

You are quite welcome.