circular reference caused by reliance of formula in another cell

[robert.begley1]

Hi all,
I am writing a new spread sheet for my book keeping
I use a formula in cell C to calculate the figure entered into cell A minus vat cell C is blank until a value is entered into cell A

=IF(AND(A1="",B1=""),"",A1/1.2)

now I want Cell B to automatically take the calculated value in cell C from the value entered in Cell A again showing a blank cell until a value is entered in cell A
I have tried several things but always come up with a circular reference.

I can limit iteration in the preferences, but this does not leave the cells blank, when no value is entered in cell A

can anyone help me, probably easy for you guys!!!

thank you for at least reading this post and hope it gives you a nice little problem to solve.

by the way this is obviously so that the VAT and nett figures are automatically calculated when putting a gross figure in cell A.

cheers
Rob

[Spencer101]

Hi Rob,

Could you post an example workbook including your formula showing a circ ref so we can have a look where it's going wrong?

EDIT:

Having read the OP again, I think this is what you need.
In C1 enter =IF(A1="","",A1/1.2) and in B1 enter =IF(A1="","",A1-C1)

Now everything stays blank until you put a value in A1.

Does that fix your problem?

S.

[robert.begley1]

Hi Spencer,
sorry for the delay in getting back to you, the in laws came round, so I had to be sociable for a bit!!!!
thank you so much for your reply, that has worked a treat.
thank you again
cheers
Rob

[Spencer101]

Not a problem Rob. I hope the visit from the in-laws wasn't TOO traumatic