I
igor058
How do I roundup a calculation in 0.2 increments?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron Coderre
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
=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
K
KL
Hi Igor,
Try this: =ROUNDUP(A1/0.2,0)*0.2
Privet,
KL
Try this: =ROUNDUP(A1/0.2,0)*0.2
Privet,
KL
P
paul
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!)
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!)