Of course you're going to have a cicular error if you put the formula in the
same box as the data entry. So don't do that. Enter 117.50 in cell A6. Put
your formula in *any other* cell, like A7.

Regards,
Fred.

"Steve" wrote in message
...
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?

Thanks in advance