If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Rounding up
Does anyone know the formula for rounding up to the next
quarters. Example 1.66 should round to 1.75, 2.11 should round to 2.25. Thanks |
#2
|
|||
|
|||
Rounding up
Hi Chris,
Try, =CEILING(A1,0.25) Hope this helps! In article , "Chris" wrote: Does anyone know the formula for rounding up to the next quarters. Example 1.66 should round to 1.75, 2.11 should round to 2.25. Thanks |
#3
|
|||
|
|||
Rounding up
Hi
Try this: =ROUNDUP(A1/0.25,0)*0.25 -- Andy. "Chris" wrote in message ... Does anyone know the formula for rounding up to the next quarters. Example 1.66 should round to 1.75, 2.11 should round to 2.25. Thanks |
Thread Tools | |
Display Modes | |
|
|