Rounding up or down depending on number
 

Would anyone know a formula for the following?

What formula would round down if the tens of thousands in a number is less
then 10,000.00 or round up if over 10,000.00? For example if cell A250 equals
506,789.90 the cell would read 506,000.00 but A250 equals 511,782.90 the cell
would read 512,000?

Rounding up or down depending on number
 

Surely the first one would round up also, to 507,000.00 ?

Try this:

=ROUND(A1,-3)

Hope this helps.

Pete

On Mar 26, 2:45*pm, JNAP101 wrote:
Would anyone know a formula for the following?

What formula would round down if the tens of thousands in a number is less
then 10,000.00 or round up if over 10,000.00? For example if cell A250 equals
506,789.90 the cell would read 506,000.00 but A250 equals 511,782.90 the cell
would read 512,000?

Rounding up or down depending on number
 

Try this:

=ROUND(A250,-3)

Does that help?

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"JNAP101" wrote in message
...
Would anyone know a formula for the following?

What formula would round down if the tens of thousands in a number is less
then 10,000.00 or round up if over 10,000.00? For example if cell A250
equals
506,789.90 the cell would read 506,000.00 but A250 equals 511,782.90 the
cell
would read 512,000?

Rounding up or down depending on number
 

Hi Pete, Thanks for the quick response!! That's the problem if the
"thousands" is less than 10k they want the number to round down and round up
if over 10.0k.

I totally stuck on what formula would work.

"Pete_UK" wrote:

Surely the first one would round up also, to 507,000.00 ?

Try this:

=ROUND(A1,-3)

Hope this helps.

Pete

On Mar 26, 2:45 pm, JNAP101 wrote:
Would anyone know a formula for the following?

What formula would round down if the tens of thousands in a number is less
then 10,000.00 or round up if over 10,000.00? For example if cell A250 equals
506,789.90 the cell would read 506,000.00 but A250 equals 511,782.90 the cell
would read 512,000?

Rounding up or down depending on number
 

=IF(MOD(A250,100000)<10000,ROUNDDOWN(A250,-3),ROUNDUP(A250,-3))
--
David Biddulph

"JNAP101" wrote in message
...
Would anyone know a formula for the following?

What formula would round down if the tens of thousands in a number is less
then 10,000.00 or round up if over 10,000.00? For example if cell A250
equals
506,789.90 the cell would read 506,000.00 but A250 equals 511,782.90 the
cell
would read 512,000?

Rounding up or down depending on number
 

Ah, I see what you mean now. David seems to have cracked it.

Pete

On Mar 26, 3:08*pm, JNAP101 wrote:
Hi Pete, Thanks for the quick response!! That's the problem if the
"thousands" is less than 10k they want the number to round down and round up
if over 10.0k.

I totally stuck on what formula would work.



"Pete_UK" wrote:
Surely the first one would round up also, to 507,000.00 ?

Try this:

=ROUND(A1,-3)

Hope this helps.

Pete

On Mar 26, 2:45 pm, JNAP101 wrote:
Would anyone know a formula for the following?

What formula would round down if the tens of thousands in a number is less
then 10,000.00 or round up if over 10,000.00? For example if cell A250 equals
506,789.90 the cell would read 506,000.00 but A250 equals 511,782.90 the cell
would read 512,000?- Hide quoted text -

- Show quoted text -