| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a Division funtion in Excel? | Excel Worksheet Functions | |||
| Division by Zero Error | Excel Worksheet Functions | |||
| DIV/0! error in SumProduct formula with no division | Excel Worksheet Functions | |||
| Division Symbol | Excel Discussion (Misc queries) | |||
| remainder in a division | Excel Worksheet Functions | |||
Linear Mode
