Home |
Search |
Today's Posts |
#1
|
|||
|
|||
rounding to next 12th
Hi:
I can't seem to locate the function that round a number in the next cell to the next number divisible by 12 (eg if 25 is typed into cell A1, the formula in A2 should come up with 36). It must always round up (not to the nearest). Thanks. |
#2
|
|||
|
|||
one way:
=CEILING(A1,12) In article , "Amie Barnes" <Amie wrote: Hi: I can't seem to locate the function that round a number in the next cell to the next number divisible by 12 (eg if 25 is typed into cell A1, the formula in A2 should come up with 36). It must always round up (not to the nearest). Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding numbers up or down | Excel Discussion (Misc queries) | |||
Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
Rounding in Trendline Equation | Charts and Charting in Excel | |||
Can I stop rounding in excel? | Excel Discussion (Misc queries) | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) |