=CEILING(9235200.23/1000,500)
On Wed, Aug 26, 2009 at 12:50 AM, jsa-dk wrote:
>
> ROUNDUP(9235200,23*2;-6)/2000
>
>
> On Aug 25, 1:39 pm, NOURREDINE BELHAJ
> wrote:
> > Hi All,
> >
> > Hope you are well.
> >
> > I would like to ROUNDUP the figure below
> >
> > 9,235,200.23 € to 9,500
> >
> > Can
MROUND(ROUNDUP(NUMBER,-2),500)
On Tue, Aug 25, 2009 at 5:09 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
> --
> Regards
>
> Nourredine BELH
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 wrote:
>
> ROUNDUP(9235200,23*2;-6)/2000
>
>
> On Aug 25, 1:39 pm, NOURR
Hi Nourredine BELHAJ
Try this formula
CEILING(F18,50)/1000
Regards
Sivakumar
On Aug 25, 4:39 pm, NOURREDINE BELHAJ
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
> --
> Regards
>
> Nour
Hi Jonell,
Thanks much appreciated.
it works fine.
Regards
Nour
2009/8/26 jonell
> On Aug 25, 9:39 pm, NOURREDINE BELHAJ
> 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 ?
> > Thank
Thanks so much
2009/8/25 jsa-dk
>
> ROUNDUP(9235200,23*2;-6)/2000
>
>
> On Aug 25, 1:39 pm, NOURREDINE BELHAJ
> 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
> > --
> > Re
ROUNDUP(9235200,23*2;-6)/2000
On Aug 25, 1:39 pm, NOURREDINE BELHAJ
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
> --
> Regards
>
> Nourredine BELHAJ
>
> +41783081988
> +33665248617
--~--~-