I don't use Excel very often, so this is probably a dumb question, but...

I want to set a range of cells (B88:B88, to be exact) so that the calculated
value is rounded up to the next integer.

Can someone explain how to do that--if, indeed I can.

Thanks

Oops--meant to say B8:B88. It's because I'm not so good at those picky
little details that I don't use Excel very often!

Sorry.



"Richard" wrote:

I don't use Excel very often, so this is probably a dumb question, but...

I want to set a range of cells (B88:B88, to be exact) so that the calculated
value is rounded up to the next integer.

Can someone explain how to do that--if, indeed I can.

Thanks

Use the Int function or roundup, rounddown functions for a single cell. Not
sure what you are doing with a range of cells, summing them?

Your range of B88:B88 is only a single cell. eg =Int(B88)

"Richard" wrote:

I don't use Excel very often, so this is probably a dumb question, but...

I want to set a range of cells (B88:B88, to be exact) so that the calculated
value is rounded up to the next integer.

Can someone explain how to do that--if, indeed I can.

Thanks

Thanks for your post.

What I'm trying to do is put a formula in a cell, but I want the result of
the formula to be rounded up to the next integer.

To be more specific: The number of people on a tour I'm leading is in A4;
and, for example, I want B10 to show the number of taxi's I'll need if each
taxi can hold no more than four people, so 5 people would require two taxis.

The first question is, can I do ROUNDUP on one cell; the second question,
can I have a range of cells--B8:B88--do the same thing without setting each
cell individually?

Thanks for any help you can give.

Richard

"Ian Grega" wrote:

Use the Int function or roundup, rounddown functions for a single cell. Not
sure what you are doing with a range of cells, summing them?

Your range of B88:B88 is only a single cell. eg =Int(B88)

"Richard" wrote:

I don't use Excel very often, so this is probably a dumb question, but...

I want to set a range of cells (B88:B88, to be exact) so that the calculated
value is rounded up to the next integer.

Can someone explain how to do that--if, indeed I can.

Thanks

Try this:

A4 = some number, say, 14

If a taxi will hold 4 people:

=CEILING(A4/4,1)

Returns: 4

Biff

"Richard" wrote in message
...
Thanks for your post.

What I'm trying to do is put a formula in a cell, but I want the result of
the formula to be rounded up to the next integer.

To be more specific: The number of people on a tour I'm leading is in A4;
and, for example, I want B10 to show the number of taxi's I'll need if
each
taxi can hold no more than four people, so 5 people would require two
taxis.

The first question is, can I do ROUNDUP on one cell; the second question,
can I have a range of cells--B8:B88--do the same thing without setting
each
cell individually?

Thanks for any help you can give.

Richard

"Ian Grega" wrote:

Use the Int function or roundup, rounddown functions for a single cell.
Not
sure what you are doing with a range of cells, summing them?

Your range of B88:B88 is only a single cell. eg =Int(B88)

"Richard" wrote:

I don't use Excel very often, so this is probably a dumb question,
but...

I want to set a range of cells (B88:B88, to be exact) so that the
calculated
value is rounded up to the next integer.

Can someone explain how to do that--if, indeed I can.

Thanks

In A4: 5
In B10: =ROUNDUP(A4/4,0)
If you have range of cells then copy down


"Richard" wrote:

Thanks for your post.

What I'm trying to do is put a formula in a cell, but I want the result of
the formula to be rounded up to the next integer.

To be more specific: The number of people on a tour I'm leading is in A4;
and, for example, I want B10 to show the number of taxi's I'll need if each
taxi can hold no more than four people, so 5 people would require two taxis.

The first question is, can I do ROUNDUP on one cell; the second question,
can I have a range of cells--B8:B88--do the same thing without setting each
cell individually?

Thanks for any help you can give.

Richard

"Ian Grega" wrote:

Use the Int function or roundup, rounddown functions for a single cell. Not
sure what you are doing with a range of cells, summing them?

Your range of B88:B88 is only a single cell. eg =Int(B88)

"Richard" wrote:

I don't use Excel very often, so this is probably a dumb question, but...

I want to set a range of cells (B88:B88, to be exact) so that the calculated
value is rounded up to the next integer.

Can someone explain how to do that--if, indeed I can.

Thanks

Thanks a lot for your tip. It does exactly what I wanted to do.

Richard




"T. Valko" wrote:

Try this:

A4 = some number, say, 14

If a taxi will hold 4 people:

=CEILING(A4/4,1)

Returns: 4

Biff

"Richard" wrote in message
...
Thanks for your post.

What I'm trying to do is put a formula in a cell, but I want the result of
the formula to be rounded up to the next integer.

To be more specific: The number of people on a tour I'm leading is in A4;
and, for example, I want B10 to show the number of taxi's I'll need if
each
taxi can hold no more than four people, so 5 people would require two
taxis.

The first question is, can I do ROUNDUP on one cell; the second question,
can I have a range of cells--B8:B88--do the same thing without setting
each
cell individually?

Thanks for any help you can give.

Richard

"Ian Grega" wrote:

Use the Int function or roundup, rounddown functions for a single cell.
Not
sure what you are doing with a range of cells, summing them?

Your range of B88:B88 is only a single cell. eg =Int(B88)

"Richard" wrote:

I don't use Excel very often, so this is probably a dumb question,
but...

I want to set a range of cells (B88:B88, to be exact) so that the
calculated
value is rounded up to the next integer.

Can someone explain how to do that--if, indeed I can.

Thanks