Prev: How do I create a travel expense report by employee, by campus
Next: In Excel, changing a range of cells to all caps.
From: Khaled on 1 Apr 2010 10:07
How can I round 980 to 1,000?
From: Pete_UK on 1 Apr 2010 10:23
With 980 in A1, you can use this:

=ROUNDUP(A1,-3)

Hope this helps.

Pete

On Apr 1, 3:07 pm, Khaled <khaled...(a)gmail.com> wrote:
> How can I round 980 to 1,000?

From: Khaled on 1 Apr 2010 10:42
It did help, thanks Pete.


On Apr 1, 4:23 pm, Pete_UK <pashu...(a)auditel.net> wrote:
> With 980 in A1, you can use this:
>
> =ROUNDUP(A1,-3)
>
> Hope this helps.
>
> Pete
>
> On Apr 1, 3:07 pm, Khaled <khaled...(a)gmail.com> wrote:
>
>
>
> > How can I round 980 to 1,000?- Hide quoted text -
>
> - Show quoted text -

From: Ashish Mathur on 3 Apr 2010 02:17
Hi,

You may also try =mround(A3,100). For Excel 2003 and prior versions, you
would have to install the Analysis Toolpak from Tools > Addins

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Khaled" <khaledity(a)gmail.com> wrote in message
news:111534c6-68ef-4b1c-994d-e24cb1ccdd1d(a)e7g2000yqf.googlegroups.com...
> How can I round 980 to 1,000?

From: "David Biddulph" groups [at] on 3 Apr 2010 12:51
=ROUND(A3,-2) will do, and that doesn't need ATP.
--
David Biddulph


"Ashish Mathur" <mathurashish(a)hotmail.com> wrote in message
news:C8D64230-7FC0-4AFF-96A5-8D09C0F46714(a)microsoft.com...
> Hi,
>
> You may also try =mround(A3,100). For Excel 2003 and prior versions, you
> would have to install the Analysis Toolpak from Tools > Addins
>
> --
> Regards,
>
> Ashish Mathur
> Microsoft Excel MVP
>
> "Khaled" <khaledity(a)gmail.com> wrote in message
> news:111534c6-68ef-4b1c-994d-e24cb1ccdd1d(a)e7g2000yqf.googlegroups.com...
>> How can I round 980 to 1,000?
>

 |  Next  |  Last
Pages: 1 2
Prev: How do I create a travel expense report by employee, by campus
Next: In Excel, changing a range of cells to all caps.