| 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 | |||
Linear Mode
