|
Need help with division, please!!!
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!!!! -- swag143 ------------------------------------------------------------------------ swag143's Profile: http://www.excelforum.com/member.php...o&userid=37602 View this thread: http://www.excelforum.com/showthread...hreadid=572236 |
Need help with division, please!!!
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 "swag143" skrev i melding ... 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!!!! -- swag143 ------------------------------------------------------------------------ swag143's Profile: http://www.excelforum.com/member.php...o&userid=37602 View this thread: http://www.excelforum.com/showthread...hreadid=572236 |
| All times are GMT +1. The time now is 01:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com