Rounding Functions

  • Thread starter Thread starter Norie Sutherland
  • Start date Start date
N

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!
 
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!
Click to expand...

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.
 
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. :-)
 
...
...
Please don't post the same question to more than one group, as this tends to
fragment responses. :-)
Click to expand...
...

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!
 
LOL

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

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



Harlan Grove said:
...
..
Please don't post the same question to more than one group, as this tends to
fragment responses. :-)
Click to expand...
..

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!
Click to expand...
 
Back
Top