I want to add 6% sales tax to the amount in a cell/column

[Bobb1220]

I have a small spread sheet that I use and 1 of the columns is used to enter
the amount paid for an item I would like to add 6% sales tax automaticly to
the amount I enter

Thanks

Bob

 

[Fredrik Wahlgren]

I have a small spread sheet that I use and 1 of the columns is used to enter
the amount paid for an item I would like to add 6% sales tax automaticly to
the amount I enter

Thanks

Bob

Assuming your data is in A1, enter =A1*1.06 in some other column.
/Fredrik

 

[Bob Phillips]

For clarity, I would use

=A1*(1+6%)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Jim May]

In your Worksheet's module paste in:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_err
Application.EnableEvents = False
If Not Intersect(Target, Range("D5:G10")) Is Nothing Then '<<<Chg to
your cell Range
Target.Value = Target.Value * 1.06
End If
ws_err:
Application.EnableEvents = True
End Sub

HTH