Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Roundup in VBA | Excel Discussion (Misc queries) | |||
=ROUNDUP(INT(0.xxx)) | Excel Worksheet Functions | |||
roundup by 16s | Excel Worksheet Functions | |||
RoundUp help! | New Users to Excel | |||
Trying To Roundup only if more than zero | Excel Discussion (Misc queries) |