Rounding to the next highest 1000 after a resulting formula
 

I need to have a column rounding up to the next highest 1000 after a resulted
formula.

ie, I4*2 = $100,200

I need the result to round to $101,000 But, the formula keeps adding the
Roundup formula resulting in 201,200.

Can I have both formulas in one cell?

=ceiling(a1,1000) to round up and
=Floor(a1,1000) to round down

"Katiemcgi" wrote in message
...
I need to have a column rounding up to the next highest 1000 after a
resulted
formula.

ie, I4*2 = $100,200

I need the result to round to $101,000 But, the formula keeps adding the
Roundup formula resulting in 201,200.

Can I have both formulas in one cell?

Yes it is possible to have both formulas in one cell
=Ceiling(I4*2,1000)

"N Harkawat" wrote in message
...
=ceiling(a1,1000) to round up and
=Floor(a1,1000) to round down

"Katiemcgi" wrote in message
...
I need to have a column rounding up to the next highest 1000 after a
resulted
formula.

ie, I4*2 = $100,200

I need the result to round to $101,000 But, the formula keeps adding the
Roundup formula resulting in 201,200.

Can I have both formulas in one cell?

=roundup(I4*2,-3)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Katiemcgi" wrote in message
...
I need to have a column rounding up to the next highest 1000 after a
resulted
formula.

ie, I4*2 = $100,200

I need the result to round to $101,000 But, the formula keeps adding the
Roundup formula resulting in 201,200.

Can I have both formulas in one cell?

I tried adding =ceiling(I4,1000) after the I4*2 and it did not work.
I4*2=ceiling(I4,1000). Any other ideas??

"N Harkawat" wrote:

=ceiling(a1,1000) to round up and
=Floor(a1,1000) to round down

"Katiemcgi" wrote in message
...
I need to have a column rounding up to the next highest 1000 after a
resulted
formula.

ie, I4*2 = $100,200

I need the result to round to $101,000 But, the formula keeps adding the
Roundup formula resulting in 201,200.

Can I have both formulas in one cell?

Thankyou. It works beautifully. All set.

"N Harkawat" wrote:

Yes it is possible to have both formulas in one cell
=Ceiling(I4*2,1000)

"N Harkawat" wrote in message
...
=ceiling(a1,1000) to round up and
=Floor(a1,1000) to round down

"Katiemcgi" wrote in message
...
I need to have a column rounding up to the next highest 1000 after a
resulted
formula.

ie, I4*2 = $100,200

I need the result to round to $101,000 But, the formula keeps adding the
Roundup formula resulting in 201,200.

Can I have both formulas in one cell?

No, in place of

=CEILING(I4*2,1000)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Katiemcgi" wrote in message
...
I tried adding =ceiling(I4,1000) after the I4*2 and it did not work.
I4*2=ceiling(I4,1000). Any other ideas??

"N Harkawat" wrote:

=ceiling(a1,1000) to round up and
=Floor(a1,1000) to round down

"Katiemcgi" wrote in message
...
I need to have a column rounding up to the next highest 1000 after a
resulted
formula.

ie, I4*2 = $100,200

I need the result to round to $101,000 But, the formula keeps adding
the
Roundup formula resulting in 201,200.

Can I have both formulas in one cell?