Formula to calculate and add tax

[storeman]

I am creating a simple (I thought) pricing guide and I am running int
the circular reference problem. Here's what I want to do. I want t
enter a price in a cell and have the tax automatically calculated an
the total price returned to the cell. I know I can create an entirel
new set of cells just to contain the price and the tax rate then hav
that result displayed in the desired cell. But, I wondered if it i
possible to enter the price directly into the cell.

For example:
In A1 A2 A3 I want to be able to enter the price before tax an
then have the tax calculated and the total displayed in the cell.

Th

 

[Guest]

Hi
not possible without using event procedures. So I'd suggest you use separate
cells

 

[Alex Delamain]

I don't think so without resorting to VB.

If you have a formula in A1 which is =A1*1.175 then every time th
spreadsheet recalculated (ie whenever any data was entered etc) then i
would increment upwards each time - not, I think, what you are after.

Best option is to use another column so you have the product pric
including and excluding VAT
A1 is price, A2=A1*1.17

 

[BenjieLop]

I am creating a simple (I thought) pricing guide and I am running int
the circular reference problem. Here's what I want to do. I want t
enter a price in a cell and have the tax automatically calculated an
the total price returned to the cell. I know I can create an entirel
new set of cells just to contain the price and the tax rate then hav
that result displayed in the desired cell. But, I wondered if it i
possible to enter the price directly into the cell.

For example:
In A1 A2 A3 I want to be able to enter the price before tax an
then have the tax calculated and the total displayed in the cell.

Thx

As far as I know, I do not think this is possible. If you make an entr
into any cell, this particular cell will always display what yo
entered.

I suggest that you make use of the numerous cells that Excel offers
For example, in this situation,

1. you can enter the base price in Cell A1
2. tax is housed in Cell A2 (is this manually entered or is this to b
looked up from somewhere?)
3. add the sum , =A1+A2 , in cell A3 to give you the total

I hope this will help