round up ?

D

dammit1

Hi,
Im trying to round up to the tens, like 127 to 130. I found a fe
threads on here but it seems to be more than I can do.

I stuck at
=ROUNDUP(A1+.........


Thanks for any tip
 
R

RagDyeR

Since you said round up to the tens, this will take 121 AND 127 up to 130:

=CEILING(C1,10)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hi,
Im trying to round up to the tens, like 127 to 130. I found a few
threads on here but it seems to be more than I can do.

I stuck at
=ROUNDUP(A1+.........


Thanks for any tips
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top