ROUNDUP IN 0.2 INCREMENTS

[Guest]

How do I roundup a calculation in 0.2 increments?

 

[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

 

[KL]

Hi Igor,

Try this: =ROUNDUP(A1/0.2,0)*0.2

Privet,
KL

 

[Guest]

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!)