rounding of numeros
Is the comma your regional decimal point?
My regional settings are English (U.S.)
A5 = 0.456
B5 = 0.637
=CEILING(A5,0.05)*CEILING(B5,0.05)
returns 0.325
Biff
"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)
|