Rounding up in multiples of 5 or 0 (or 'x' number)

[Calculon]

I would like to be able to round up to a given next higher digit. Say for instance I have the following values:

16
19
21
34

I would like the following results:

16 rounding up to 20
19 rounding up to 20
21 rounding up to 25
34 rounding up to 35

What would be the formula?

By the way the copy of office Mac 2008 I bought came without a manual...

Thanks.

 

[Bob Greenblatt]

I would like to be able to round up to a given next higher digit. Say for
instance I have the following values:

16
19
21
34

I would like the following results:

16 rounding up to 20
19 rounding up to 20
21 rounding up to 25
34 rounding up to 35

What would be the formula?

By the way the copy of office Mac 2008 I bought came without a manual...

Thanks.

The function you want is Ceiling. If 16 is in A1, the the formula would be
=ceiling(a1,5). Fill this down as needed.

And, by the way all copies of Office 2008, not just yours, do not come with
a manual. Feel free to ask here for assistance, or check with the
application's Help.

 

[CyberTaz]

Bob G has provided your solution, but just extending on the one point...

Most software today does come without any printed documentation other than
basic instruction on installation. Virtually all instruction, tutorials,
etc. is electronically available ‹ usually via Help &/or the developer's web
site. There may be OEM or 3rd party printed material available but it is
often out of date before it hits the streets.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Calculon]

Thank you, that was exactly what I was looking for.

Now, what if I introduce a variant; for instance:

A B C
1 Apple $1 Red
2 Pear $2 Green
3 Grapes $3 Purple

Say I place a drop-down menu in A4 where I can choose between Apple, Pear and Grapes. In B4 the amount in $ will appear, exactly as what I requested earlier. But if I would like a description to be added in C4, how would I go about achieving this? So if I select 'Pear' in the drop-down menu in A4, '2$' will appear in B4 and I would like 'Green' to appear in C4.

Thanks.

 

[Calculon]

SORRY WRONG THREAD, MY BAD!