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

"juanpablo" wrote in message
...
Now if I have 7,1 it wont make it 7,15 why?

"Peo Sjoblom" wrote:

MULTIPLO.SUPERIOR

=MULTIPLO.SUPERIOR(A2;0;05)

or

=MULTIPLO.SUPERIOR(A2,0,05)


depending on what delimiter you are using


--


Regards,


Peo Sjoblom

"juanpablo" wrote in message
...
Great thanks,
but to make world more complicated what is ceiling in spanish excel????



"David Biddulph" wrote:

=CEILING(A2,0.05)
--
David Biddulph

"juanpablo" wrote in message
...
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?