RoundUP

J

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?
 
K

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

Kevin B

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

Sorry for the mishap...
 
J

juanpablo

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

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
 
J

juanpablo

Thank you so much.

Peo Sjoblom said:
MULTIPLO.SUPERIOR

=MULTIPLO.SUPERIOR(A2;0;05)

or

=MULTIPLO.SUPERIOR(A2,0,05)


depending on what delimiter you are using


--


Regards,


Peo Sjoblom
Click to expand...
 
J

juanpablo

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

Peo Sjoblom said:
MULTIPLO.SUPERIOR

=MULTIPLO.SUPERIOR(A2;0;05)

or

=MULTIPLO.SUPERIOR(A2,0,05)


depending on what delimiter you are using


--


Regards,


Peo Sjoblom
Click to expand...
 
P

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
 
Top