| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Round up to 100?
I'm trying to construct a worksheed formula that will round up to the
nearest 100. f(26,335.37) = 26,400.00 |
|
#2
|
|||
|
|||
|
One way:
=CEILING(A1,100) Another: =ROUNDUP(A1,-2) In article , Fred Holmes wrote: I'm trying to construct a worksheed formula that will round up to the nearest 100. f(26,335.37) = 26,400.00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round Time with Conditions | Charts and Charting in Excel | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
| Round Up Time IF | Excel Worksheet Functions | |||
| How can i round off .10 as .50 and .51 as 1.00 | Excel Worksheet Functions | |||
| Round Time | Excel Worksheet Functions | |||
Linear Mode
