RoundUP

[juanpablo]

If I have 8,64 and I need to round the number to 8,65?
Or if I have 3,21 and round the number to the nearest 5 to 3,25

How can be done?

 

[Kevin B]

Something along these lines might do the trick for you:

=IF(MOD(A1,0.5)=0,A1,A1+(0.05-MOD(A1,0.05)))

 

[Per Jessen]

Hi

=CEILING(8.64,0.05)

Regards,
Per

 

[Kevin B]

Disregard my previous post. I posted too quickly and did not fully check my
logic.

Sorry for the mishap...

 

[Mike H]

try

=CEILING(A1,0.05)

Mike

 

[juanpablo]

Great thanks,
but to make world more complicated what is ceiling in spanish excel????

 

[Peo Sjoblom]

MULTIPLO.SUPERIOR

=MULTIPLO.SUPERIOR(A2;0;05)

or

=MULTIPLO.SUPERIOR(A2,0,05)


depending on what delimiter you are using


--


Regards,


Peo Sjoblom

 

[juanpablo]

Thank you so much.

MULTIPLO.SUPERIOR

=MULTIPLO.SUPERIOR(A2;0;05)

or

=MULTIPLO.SUPERIOR(A2,0,05)


depending on what delimiter you are using


--


Regards,


Peo Sjoblom

 

[juanpablo]

Now if I have 7,1 it wont make it 7,15 why?

MULTIPLO.SUPERIOR

=MULTIPLO.SUPERIOR(A2;0;05)

or

=MULTIPLO.SUPERIOR(A2,0,05)


depending on what delimiter you are using


--


Regards,


Peo Sjoblom

 

[Peo Sjoblom]

Because you asked for it to round to the nearest 0.05 and the nearest
0.05 of 7.10 is 7.10. What do you want the result to be if the value is
7.17?
--


Regards,


Peo Sjoblom