=ROUND(A1,2)+0.05*(ROUND(A1,2)<ROUNDUP(A1,2))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"valtinho" wrote in message
...
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)