rounding of numeros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
I am not sure that I follow you but I think you want

=CEILING(A1,0.05)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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?
 
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
 
Back
Top