Oughtn't it to be =ROUNDUP(A1*20,0)/20,
if the OP wants a multiple of 0.05, as he gave in his examples?
--
David Biddulph

"Gary''s Student" wrote in message
...
=ROUNDUP(A1/50,0)*50

"valtinho" wrote:

As to make it formulates it of a column to calculate another
column and that the numeros to be calculated
are multiplos of 5 in 5
example of the question 0,345 = 0,350
0,496 = 0,500
0,500 = 0,500
0.501 = 0,550
0,550 = 0,550
0.551 = 0,600
0,595 = 0,600
(former... A5*B5) (A5 0,456 * B5 0,637) former of the presentation of I
calculate it
(former... A5*B5) (A5 0,5 * b5 0,65) resulting (0,325)