Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Rounding | Excel Worksheet Functions | |||
Rounding | Excel Worksheet Functions | |||
Rounding to 5.0 or 0.0 | Excel Discussion (Misc queries) | |||
Excel - BAHTTEXT (Converter numeros em palavras) | Excel Discussion (Misc queries) |