rounding of numeros
 

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)

rounding of numeros
 

=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)

rounding of numeros
 

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)

"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)

rounding of numeros
 

=ROUNDUP(A1/50,0)*50
--
Gary''s Student - gsnu200728


"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)

rounding of numeros
 

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)

rounding of numeros
 

You are right. I forgot that his comma is my period.
--
Gary''s Student - gsnu200728


"David Biddulph" wrote:

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)

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)