Don't really understand what you are getting at. I don't want to put the
value in a different cell because I want to keep the table simple, if you
could see what I was trying to achieve it would make more sense. I don't know
how to devise a VBA solution, that's what I need help with....

"David Biddulph" wrote:

How much extra do you have to pay to Microsoft to use the extra cells? :-)
But if you prefer to devise a VBA solution rather than using the simple
formula option, and if you are happy that you can keep track of which of the
values in the same column ae including VAT and which are excluding, then you
are welcome to do so.
--
David Biddulph

"Steve" wrote in message
...
You are correct with your understanding, but in the table I am trying to
create, I want it in the same cell and not in another as you suggest. I
have
a series of columns with different headings that I want the amount in less
the VAT. I have to put that in first and then it will be calculated in a
totals column inclusive of VAT. As I would have the figures inc. VAT it
would
save me the time calculating the - VAT before I put it. If I use a
different
cell I would have twice as many and it wouldn't make any sense. I hope
this
explains it, I know it it is not a common thing to do, thats why I need
help
:)

"smartin" wrote:

Steve wrote:
Hi, I want to be able to put a figure in a cell that is inclusive of
VAT and
for it to then become the amount less VAT at 17.5 %. ie if I put in box
A6
117.5 I want it to become 100. I know the sum is (A6)/1.175 but it
gives a
circular reference error. I tried doing what the help said and ticking
the
iteration box but it didnt seem to help. Is there any way of doing
this?

Hi Steve,

Let me make sure I understand the dilemma: You want to type 117.5 in A6
and this cell will then somehow morph to a value of 100?

Perhaps this is possible with VBA code, but why? Why not enter a value
inclusive of VAT in A6 and then calculate the value exclusive of VAT in
a new cell as =A6/1.175 ?