Tax Rate Cell

[hhammash]

Hi,

I have in cell A3 a value for Tax rate (0.037216), and in b5 I have a formula to calculate the tax for the purchase price =A5*A3/100. The tax rate might change after a month or so, how can the user, who is an old man, change the value in A3 without affecting the already calculated cells.

Example:
From A5 to A23 the tax was calculated based on 0.037216, how can the user change the tax rate in cell A3 to (0.037145) and affect only the new rows and keep the calculated values from A5 to A23 untouched (based on the old tax rate).

Thanks

 

[hhammash]

Hi,

The values in the previously calculated cells is still the formula =A8*A$3/100 and is still being affected by the change.

Maybe I am applying this in a wrong way. What I am doing is click on A3 then:
Tools > Macro > Visual Basic Editor > Paste the code then editing the range from
With Range("$B$5:$B" to With Range("$B$5:$B1004" > Save.

When I go back to A3 and change the value all the values in B column are effected.

Thanks

 

[andrewman]

Ow often will the tax rate change? If its yearly or on specified dates you could buil a tax table and use a vlookup tied to dates to reference, you wont be able to change it using just one cell and one rate. VBA may work that way, doubt a single cell formula would though

Scottylad2's idea is good & correct, your case should not use VBA. Vlookup is okay. e.g. vlookup(input_date,tax_table,2,1)