Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ROUNDUP IN 0.2 INCREMENTS
How do I roundup a calculation in 0.2 increments?
|
#2
|
|||
|
|||
If none of the values will be negative:
=CEILING(A1,0.2) If they can be positive or negative and you truly want the value to round up to a larger value: =IF(A1<0,-FLOOR(ABS(A1),0.2),CEILING(A1,0.2)) Does that help? Ron |
#3
|
|||
|
|||
Hi Igor,
Try this: =ROUNDUP(A1/0.2,0)*0.2 Privet, KL "igor058" wrote in message ... How do I roundup a calculation in 0.2 increments? |
#4
|
|||
|
|||
MROUND
See Also Returns a number rounded to the desired multiple. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. How? On the Tools menu, click Add-Ins. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK. If necessary, follow the instructions in the setup program. Syntax MROUND(number,multiple) Number is the value to round. Multiple is the multiple to which you want to round number. Remark MROUND rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple. Examples Formula Description (Result) =MROUND(10, 3) Rounds 10 to a nearest multiple of 3 (9) =MROUND(-10, -3) Rounds 10 to a nearest multiple of 3 (-9) =MROUND(1.3, 0.2) Rounds 1.3 to a nearest multiple of 0.2 (1.4) =MROUND(5, -2) Returns an error, because -2 and 5 have different signs (#NUM!) -- paul remove nospam for email addy! "igor058" wrote: How do I roundup a calculation in 0.2 increments? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I apply the ROUNDUP formula to a range of calculated data | Excel Worksheet Functions | |||
formula for defining axis maximum and increments | Charts and Charting in Excel | |||
How do I use Roundup in a logical test in excel | Excel Worksheet Functions | |||
roundup seconds to minute | Excel Worksheet Functions | |||
Roundup | Excel Worksheet Functions |