| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rounding a calculation down to the nearest 0.5 - how?
The following function might work for you:
=IF(MOD(A1,1)=0.5,INT(A1)+0.5,A1) The MOD function divides the value in a1 by 1 and returns the remainder, if the remainder is = .5, it adds .5 to the integer value in A1, otherwise it returns A1 -- Kevin Backmann "Suza" wrote: need to calculate holidays based on no of weeks worked x entitlement = ROUNDED DOWN TO NEAREST 0.5 DAY Able to round down but can't understand the 1/2 day |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the formula for rounding a dollar amount to the nearest ni | New Users to Excel | |||
| rounding to nearest hundred dollar in Excel | New Users to Excel | |||
| Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
| Rounding up to the nearest nickel | Excel Discussion (Misc queries) | |||
| Rounding to nearest integer | Excel Worksheet Functions | |||
Hybrid Mode
