Need help with division, please!!!

  • Thread starter Thread starter swag143
  • Start date Start date
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!!!!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i create a divisible formula 3
Excel Need Countifs Formula Help 0
Vlookup help 2
Problem with excel. Please Help!! 0
formula question 3
How to divide numbers in Excel? 0
How do I write formula to check a range of cells? 5
[ask] Quartile and Frequency 0

Back
Top