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