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