Problem With Formula

[Mark Stephens]

I am trying to use the IF function to calculate a sales tax rate. We have three different locations. One is Bedford, one is Tidewater, and one is Richmond. The sales tax rate for Tidewater is 6%, and Bedford and Richmond are 5.3%.

I have a drop down box in a cell asking what branch. You select one of the three. Down in the bottom of the spreadsheet, I have a cell for the tax that is supposed to multiply the amount of a cell and the sales tax rate. I want the sales tax cell to automatically pick the right sales tax based on which branch is selected above. My formula looks like this:

=IF(B3="Bedford", E37*5.3%)=IF(B3="Richmond", E37*5.3%)=IF(B3="Tidewater", E37*6%)

In that cell, all it says is TRUE, so I'm assuming the formula is incorrect. Can someone please help me with this. First time user here, once I learn some more I will help others!

Take care,

Mark Stephens

[Jonmo1]

I think you probably want

=IF(B3="Bedford", E37*5.3%,IF(B3="Richmond", E37*5.3%,IF(B3="Tidewater", E37*6%)))

[ChemistB]

=IF(B3="Bedford", E37*5.3%, IF(B3="Richmond", E37*5.3%,IF(B3="Tidewater", E37*6%,"N/A")))

Can be simplified to
=IF(OR(B3="Bedford", B3= "Richmond"), 5.3%, IF(B3 = "Tidewater", 6%))* E37

or even, assuming only Richmond, Tidewater or Bedford will be in B3

= IF(OR(B3 = {"Bedford", "Richmond"}), 5.3%, 6.0%) * E37

[Jonmo1]

Actually, if B3 is only 1 of 3 values, we really only need to test if B3 = "Tidewater" (the one that's different from the other 2)
If it's NOT Tidewater, it therefore must be one of the other 2.

=IF(B3="Tidewater",6%,5.3%)*E37

[ChemistB]

Good point Jon. My brain is thinking left to right again.