| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Different kind of rounding
I need help with this one...
If the 3rd digit after the decimal is not a zero, I need to round up the 2nd digit, otherwise leave the number as is Examples: 4.240 would be 4.24 4.241 would be 4.25 I'd like to be able to do this in one step/one formula. Any suggestions?? Thank you, Sarah |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ?? Some kind of look up function - Help and Thanks A Lot! | Excel Worksheet Functions | |||
| Don't know what kind of question this is? | Excel Discussion (Misc queries) | |||
| Hi Everyone! Im a Student so please be kind... | Charts and Charting in Excel | |||
| kind of chart? | Charts and Charting in Excel | |||
| Is this kind of count possible?... | Excel Worksheet Functions | |||
Threaded Mode
