Set a range of cells for ROUNDUP

[Guest]

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

 

[Guest]

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.

 

[Guest]

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)

 

[Guest]

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

 

[T. Valko]

Try this:

A4 = some number, say, 14

If a taxi will hold 4 people:

=CEILING(A4/4,1)

Returns: 4

Biff

 

[Guest]

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

 

[Guest]

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

Richard