| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding up to a multiple of 12
I want to add several columns, subtract several columns and if the result is
gt zero I want to add 1 to it, divide by 2 and then round up to a multiple of 12. If the result is 0 I want the result to be a space. I know about the ceiling statement (sort of) but Can I do this in one statement somehow? =IF(E5+H5+K5+L5-F5-M5-P50,SUM(E5+H5+K5+L5-F5-M5-P5+1)/2,"") In a different column I can insert =CEILING(I5,12) - but if the result is 0 it displays 0 instead of a space |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| Need help in rounding answers to nearest multiple | Excel Worksheet Functions | |||
| Formula for rounding a column of currency to a multiple | Excel Worksheet Functions | |||
| Excel Rounding Up to Nearest Multiple | Excel Worksheet Functions | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Threaded Mode
