Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I am trying to round up to the nearest 25 cents
I am trying to round a money value to the nearsest 25 cents and it keeps
rounding to the nearest dollar HELP |
#2
|
|||
|
|||
Try
=CEILING(A1, 0.25) In article , sypher wrote: I am trying to round a money value to the nearsest 25 cents and it keeps rounding to the nearest dollar HELP |
#3
|
|||
|
|||
=ROUND(A1*4,0)/4
-- HTH Bob Phillips "sypher" wrote in message ... I am trying to round a money value to the nearsest 25 cents and it keeps rounding to the nearest dollar HELP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round time to nearest quarter hr | Excel Worksheet Functions | |||
How do I format cells to round to the nearest thousands without .. | Excel Discussion (Misc queries) | |||
WHAT SYNTAX IS USED TO ROUND A 4-DIGIT NUMBER TO THE NEAREST THOUS | Excel Discussion (Misc queries) | |||
WHATS AN EASY FUNCTION TO USE TO ROUND TO THE NEAREST THOUSAND? | Excel Worksheet Functions | |||
How can I round an hour to the nearest 1/4 hour? | Excel Worksheet Functions |