|
RoundUP
If I have 8,64 and I need to round the number to 8,65?
Or if I have 3,21 and round the number to the nearest 5 to 3,25 How can be done? |
RoundUP
Something along these lines might do the trick for you:
=IF(MOD(A1,0.5)=0,A1,A1+(0.05-MOD(A1,0.05))) -- Kevin Backmann "juanpablo" wrote: If I have 8,64 and I need to round the number to 8,65? Or if I have 3,21 and round the number to the nearest 5 to 3,25 How can be done? |
RoundUP
Hi
=CEILING(8.64,0.05) Regards, Per "juanpablo" skrev i meddelelsen ... If I have 8,64 and I need to round the number to 8,65? Or if I have 3,21 and round the number to the nearest 5 to 3,25 How can be done? |
RoundUP
Disregard my previous post. I posted too quickly and did not fully check my
logic. Sorry for the mishap... -- Kevin Backmann "juanpablo" wrote: If I have 8,64 and I need to round the number to 8,65? Or if I have 3,21 and round the number to the nearest 5 to 3,25 How can be done? |
RoundUP
=CEILING(A2,0.05)
-- David Biddulph "juanpablo" wrote in message ... If I have 8,64 and I need to round the number to 8,65? Or if I have 3,21 and round the number to the nearest 5 to 3,25 How can be done? |
RoundUP
try
=CEILING(A1,0.05) Mike "juanpablo" wrote: If I have 8,64 and I need to round the number to 8,65? Or if I have 3,21 and round the number to the nearest 5 to 3,25 How can be done? |
RoundUP
Great thanks,
but to make world more complicated what is ceiling in spanish excel???? "David Biddulph" wrote: =CEILING(A2,0.05) -- David Biddulph "juanpablo" wrote in message ... If I have 8,64 and I need to round the number to 8,65? Or if I have 3,21 and round the number to the nearest 5 to 3,25 How can be done? |
RoundUP
MULTIPLO.SUPERIOR
=MULTIPLO.SUPERIOR(A2;0;05) or =MULTIPLO.SUPERIOR(A2,0,05) depending on what delimiter you are using -- Regards, Peo Sjoblom "juanpablo" wrote in message ... Great thanks, but to make world more complicated what is ceiling in spanish excel???? "David Biddulph" wrote: =CEILING(A2,0.05) -- David Biddulph "juanpablo" wrote in message ... If I have 8,64 and I need to round the number to 8,65? Or if I have 3,21 and round the number to the nearest 5 to 3,25 How can be done? |
RoundUP
http://dolf.trieschnigg.nl/excel/excel.html
http://www.mvps.org/dmcritchie/excel/language.htm http://cherbe.free.fr/traduc_fonctions_xl97.html -- David Biddulph "juanpablo" wrote in message ... Great thanks, but to make world more complicated what is ceiling in spanish excel???? "David Biddulph" wrote: =CEILING(A2,0.05) -- David Biddulph "juanpablo" wrote in message ... If I have 8,64 and I need to round the number to 8,65? Or if I have 3,21 and round the number to the nearest 5 to 3,25 How can be done? |
RoundUP
Thank you so much.
"Peo Sjoblom" wrote: MULTIPLO.SUPERIOR =MULTIPLO.SUPERIOR(A2;0;05) or =MULTIPLO.SUPERIOR(A2,0,05) depending on what delimiter you are using -- Regards, Peo Sjoblom "juanpablo" wrote in message ... Great thanks, but to make world more complicated what is ceiling in spanish excel???? "David Biddulph" wrote: =CEILING(A2,0.05) -- David Biddulph "juanpablo" wrote in message ... If I have 8,64 and I need to round the number to 8,65? Or if I have 3,21 and round the number to the nearest 5 to 3,25 How can be done? |
RoundUP
Now if I have 7,1 it wont make it 7,15 why?
"Peo Sjoblom" wrote: MULTIPLO.SUPERIOR =MULTIPLO.SUPERIOR(A2;0;05) or =MULTIPLO.SUPERIOR(A2,0,05) depending on what delimiter you are using -- Regards, Peo Sjoblom "juanpablo" wrote in message ... Great thanks, but to make world more complicated what is ceiling in spanish excel???? "David Biddulph" wrote: =CEILING(A2,0.05) -- David Biddulph "juanpablo" wrote in message ... If I have 8,64 and I need to round the number to 8,65? Or if I have 3,21 and round the number to the nearest 5 to 3,25 How can be done? |
RoundUP
Because you asked for it to round to the nearest 0.05 and the nearest
0.05 of 7.10 is 7.10. What do you want the result to be if the value is 7.17? -- Regards, Peo Sjoblom "juanpablo" wrote in message ... Now if I have 7,1 it wont make it 7,15 why? "Peo Sjoblom" wrote: MULTIPLO.SUPERIOR =MULTIPLO.SUPERIOR(A2;0;05) or =MULTIPLO.SUPERIOR(A2,0,05) depending on what delimiter you are using -- Regards, Peo Sjoblom "juanpablo" wrote in message ... Great thanks, but to make world more complicated what is ceiling in spanish excel???? "David Biddulph" wrote: =CEILING(A2,0.05) -- David Biddulph "juanpablo" wrote in message ... If I have 8,64 and I need to round the number to 8,65? Or if I have 3,21 and round the number to the nearest 5 to 3,25 How can be done? |
| All times are GMT +1. The time now is 02:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com