Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
roundup, ceiling or whatever
I would like to create a calculation that rounds to the next higher 9000 and
add 900. I wonder if this can be done? Example: a home price calculates to $447,865.75 in value. I want to make a price of $449,900. It would be nice if this solution could work in the five digit area also such as a home calculating to $46,789.56 rounded up to $49,900. An ideas? Thanks all, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
roundup, ceiling or whatever
One way:
=CEILING(A1,10000)-100 In article , "Blake" wrote: I would like to create a calculation that rounds to the next higher 9000 and add 900. I wonder if this can be done? Example: a home price calculates to $447,865.75 in value. I want to make a price of $449,900. It would be nice if this solution could work in the five digit area also such as a home calculating to $46,789.56 rounded up to $49,900. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ROUNDUP vs CEILING | Excel Worksheet Functions | |||
Ceiling problem. | Excel Discussion (Misc queries) | |||
Roundup or Ceiling Function to round to a specific number | Excel Discussion (Misc queries) | |||
ceiling | Excel Discussion (Misc queries) | |||
Max, Ceiling, If, Etc | Excel Discussion (Misc queries) |