Calculating Tax %
 

hi i have an order form that i want to calculate a tax of 5% on all orders,
meaning any ordered goods will have a 5% tax charge on them how do i do it.
thanks

Calculating Tax %
 

Hi,

Where A1 is the goods price

=A1*1.05

Mike

"Amin" wrote:

hi i have an order form that i want to calculate a tax of 5% on all orders,
meaning any ordered goods will have a 5% tax charge on them how do i do it.
thanks

Calculating Tax %
 

How you do it in your calculator?


"Amin" wrote:

hi i have an order form that i want to calculate a tax of 5% on all orders,
meaning any ordered goods will have a 5% tax charge on them how do i do it.
thanks

Calculating Tax %
 

Hi,

Mike's suggestion is best but think of it this way

5%*$200 = $10
total = 200+10
so you could write it
=A1+5%*A1 or =A1+0.05*A1

--
Thanks,
Shane Devenshire


"Amin" wrote:

hi i have an order form that i want to calculate a tax of 5% on all orders,
meaning any ordered goods will have a 5% tax charge on them how do i do it.
thanks