| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I round a number to the nearest "50" or "100" in excel 200
I have a odd number and would like to round it off the nearest 50 or 100
whichever is closer. Can that be done? If yes how. Thanks |
|
#2
|
|||
|
|||
|
what to do with 75?
"Manny" schreef in bericht ... I have a odd number and would like to round it off the nearest 50 or 100 whichever is closer. Can that be done? If yes how. Thanks |
|
#3
|
|||
|
|||
|
In article ,
says... I have a odd number and would like to round it off the nearest 50 or 100 whichever is closer. Can that be done? If yes how. Thanks Since 100 is a multiple of 50, just round to 50. It will yield the necessary result. If the number of interest is in A1, use =ROUND(A1/50,0)*50. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
| Rounding up to the nearest nickel | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
