Home |
Search |
Today's Posts |
#1
|
|||
|
|||
round numbers to the nearest quarter?
How do you round numbers to the nearest quarter?
|
#2
|
|||
|
|||
One way:
=ROUND(A1*4,0)/4 In article , LeelooIvy wrote: How do you round numbers to the nearest quarter? |
#3
|
|||
|
|||
Another........
=MROUND(A1,0.25) or if you're doing pricing you may want =ROUNDUP(A1*4,0)/4 Vaya con Dios, Chuck, CABGx3 "JE McGimpsey" wrote in message ... One way: =ROUND(A1*4,0)/4 In article , LeelooIvy wrote: How do you round numbers to the nearest quarter? |
#4
|
|||
|
|||
Or even:
=CEILING(A1,0.25) (for an alternative for the =roundup() sample) CLR wrote: Another........ =MROUND(A1,0.25) or if you're doing pricing you may want =ROUNDUP(A1*4,0)/4 Vaya con Dios, Chuck, CABGx3 "JE McGimpsey" wrote in message ... One way: =ROUND(A1*4,0)/4 In article , LeelooIvy wrote: How do you round numbers to the nearest quarter? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i need an excell formula that will round up to the nearest 9.99 | Excel Worksheet Functions | |||
Round Up to Nearest 10 | Excel Worksheet Functions | |||
Round time to nearest quarter hr | Excel Worksheet Functions | |||
Rounding numbers to the nearest thousand | Excel Discussion (Misc queries) | |||
Rounding number to the nearest quarter | Excel Worksheet Functions |