ExcelBanter - Rounding up

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Rounding up (https://www.excelbanter.com/excel-discussion-misc-queries/264063-rounding-up.html)

M Thompson

Rounding up

Hi

Please-How do you round up to the nearest $1000.00?

Thanks!
--
OneFineDay

Mike H

Rounding up

Hi,

Your question is unclear. Do you mean round up to next 1000?

=CEILING(A1,1000)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

"M Thompson" wrote:

Hi

Please-How do you round up to the nearest $1000.00?

Thanks!
--
OneFineDay

M Thompson

Rounding up

You read my mind. That worked perfectly. Thanks!
--
OneFineDay

"Mike H" wrote:

Hi,

Your question is unclear. Do you mean round up to next 1000?

=CEILING(A1,1000)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

"M Thompson" wrote:

Hi

Please-How do you round up to the nearest $1000.00?

Thanks!
--
OneFineDay

All times are GMT +1. The time now is 11:27 AM.