Division or Multiplication in two adjation cells

[AlanWade]

Hi,
What I am wondering is if two cells e.g. A1 and B1 and you enter a figure into A1 then B1 will multiply that figure by 12 but (here's where it confuses me) if you enter a figure in B1 then A1 will divide it by 12. I am trying to do it without the help of using extra cells but cannot find a way with conditional formatting.
Just to clarify if 2 was entered into A1 then B1 would show 24 but if you entered 36 into B1 then A1 would show 3

Can that be done?

Thankyou for any and all replies.

Alan

[AliGW]

Administrative Note:

Sorry, you are going to need to try a bit harder!

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[AlanWade]

Changed the title but not sure how to describe it properly.

If A1 has a figured entered into it then B1 will take that figure and multiply it by 12 but if B1 has a figured entered into it then A1 will take that figure and divide it by 12 is the only way I know how to describe it.

[bebo021999]

A single cell can not be a static value and formula at same time.
VBA would be right solution.

[AlanWade]

Thanks for the answer, could you point me in the right direction as to how to write VBA to make it work.