Need help with division, please!!!

S

swag143

Can someone please tell me how to create a formula that will allow me to
divide a number in half in the same cell of the initial number. In
other words, if I type in the number 1000, I want a formula that will
convert that same number to 500 as soon as I hit tab, enter, or
whatever...
Thanks!!!!
 
H

Harald Staff

A cell can contain a constant OR a formula. Not both. You will need VBA for
this. But a worksheet has close to 17 million cells, so I believe you can
afford one extra to perform your division.

HTH. Best wishes Harald
 
Top