Rounding Functions

[Norie Sutherland]

How can I get Excel to automatically round a number up to the nearest $500
or $1000, etc. For example: $24,123 to be rounded to $24,000. Anyone know
how to do that? email: (e-mail address removed). Thanks!

 

[Harlan Grove]

How can I get Excel to automatically round a number up to the nearest $500
or $1000, etc. For example: $24,123 to be rounded to $24,000. Anyone know
how to do that? email: (e-mail address removed). Thanks!

Post questions here, read replies here.

24,123 doesn't round 'up' to 24,000. If you mean round (up or down) to nearest
500, then if you have the Analysis ToolPak loaded use

=MROUND(24123,500)

If not, use

=ROUND(24123/500,0)*500

Replace 500 with 1000 in all instances to round to nearest 1000.

 

[Ken Wright]

And seeing as you slipped through Harlan's radar, I'll do the lecturing:-

Please don't post the same question to more than one group, as this tends to
fragment responses.

 

[Harlan Grove]

...
...

Please don't post the same question to more than one group, as this tends to
fragment responses.

...

I've given up scolding multiposters. I'll save the bile for those who confuse it
with crossposting. Maybe I'll start responding to multiple posts in igpay
atinlay. Fun way to use regular expressions. My dialect:

=subst(subst(LOWER(msg),"\b([aeiou][a-z]*)('[a-z]*|\b)","$1$2way"),
"(^|[^'])\b([b-df-hj-np-tv-z]+)([aeiou][a-z]*)('[a-z]*|\b)","$1$3$4$2ay")

Have a nice day! --> avehay away icenay ayday!

ifway atthay on'tday arescay 'emway aightstray, othin'nay illway!

 

[Daniel.M]

ifway atthay on'tday arescay 'emway aightstray, othin'nay illway!

ollay ;-)

Daniel M.

 

[Ken Wright]

LOL

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

...
..

Please don't post the same question to more than one group, as this tends to
fragment responses.

..

I've given up scolding multiposters. I'll save the bile for those who confuse it
with crossposting. Maybe I'll start responding to multiple posts in igpay
atinlay. Fun way to use regular expressions. My dialect:

=subst(subst(LOWER(msg),"\b([aeiou][a-z]*)('[a-z]*|\b)","$1$2way"),
"(^|[^'])\b([b-df-hj-np-tv-z]+)([aeiou][a-z]*)('[a-z]*|\b)","$1$3$4$2ay")

Have a nice day! --> avehay away icenay ayday!

ifway atthay on'tday arescay 'emway aightstray, othin'nay illway!