$$Excel-Macros$$ Re: ROUNDUP

2009-08-26 Thread NOURREDINE BELHAJ
Thanks so much 2009/8/25 jsa-dk johannes.saugbj...@mail.tele.dk ROUNDUP(9235200,23*2;-6)/2000 On Aug 25, 1:39 pm, NOURREDINE BELHAJ nourredine.bel...@gmail.com wrote: Hi All, Hope you are well. I would like to ROUNDUP the figure below 9,235,200.23 € to 9,500 Can you

$$Excel-Macros$$ Re: ROUNDUP

2009-08-26 Thread NOURREDINE BELHAJ
Hi Jonell, Thanks much appreciated. it works fine. Regards Nour 2009/8/26 jonell jon...@live.com.au On Aug 25, 9:39 pm, NOURREDINE BELHAJ nourredine.bel...@gmail.com wrote: Hi All, Hope you are well. I would like to ROUNDUP the figure below 9,235,200.23 € to 9,500 Can you

$$Excel-Macros$$ Re: ROUNDUP

2009-08-26 Thread Siva
Hi Nourredine BELHAJ Try this formula CEILING(F18,50)/1000 Regards Sivakumar On Aug 25, 4:39 pm, NOURREDINE BELHAJ nourredine.bel...@gmail.com wrote: Hi All, Hope you are well. I would like to ROUNDUP the figure below 9,235,200.23 € to 9,500 Can you please advise ? Thanks --

$$Excel-Macros$$ Re: ROUNDUP

2009-08-26 Thread vivek agrawal
Simple and best =CEILING(9235200.23,50)/1000 hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 26, 2009 at 12:50 AM, jsa-dk johannes.saugbj...@mail.tele.dkwrote: ROUNDUP(9235200,23*2;-6)/2000