|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 15th, 2003, 08:56 PM
|
|||
|
|||
Rounding up at 4
I believe that, by default, Excel 2002 rounds up at 5.
Example: 24.445 is rounded up to 24.45 How would I go about getting Excel 2002 to round at 4? Example: 24.444 rounded up to 24.45 Any help you could provide would be greatly appreciated. Thank you. 
|
|
#2
September 15th, 2003, 09:42 PM
|
|||
|
|||
|
Rounding up at 4
Try,
=ROUND(A1/0.005,0)*0.005 or with ATP installed =MROUND(A1,0.005) -- Regards, Peo Sjoblom "Micheline Morin" wrote in message ... I believe that, by default, Excel 2002 rounds up at 5. Example: 24.445 is rounded up to 24.45 How would I go about getting Excel 2002 to round at 4? Example: 24.444 rounded up to 24.45 Any help you could provide would be greatly appreciated. Thank you.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
