Calculations in Two Cells Based on Each Other

[WillCHA]

A1
A2 B2

I am trying to come up with a formula for A1 and A2 to calculate the following.

If A1 is zero then subtract all of B2 from A2, if A2 is zero then subtract all of B2 from A1, if both A1 and A2 are greater than zero then subtract half of B2 from both A1 and A2.

Does that make sense?

[Richard Buttrey]

Unfortunately your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[WillCHA]

Sorry about the title. I hope this change works.

[JohnTopley]

You cannot put both a value and formula in same cell: you need VBA if you want results in A1 and A2.

....... and as pointed out by Ford in the following post the result could be an endless loop.

[FDibbins]

If I understand you correctly, you want a cell to base a calc on itself?

If so, then no, you cannot do that, it will create a circ reference error (well you can, but you then need to control the endless loop that would result.)

If that was not what you wanted, please try to explain again, and show some sample data and answers?

[WillCHA]

I guess I will have to do some calculating in hidden columns to get the result I need in A1 and A2.
Thanks.