round up ?
 

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


--
dammit1
------------------------------------------------------------------------
dammit1's Profile: http://www.excelforum.com/member.php...o&userid=16311
View this thread: http://www.excelforum.com/showthread...hreadid=277016

=CEILING(A1,10)

"dammit1" wrote in message
...

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


--
dammit1
------------------------------------------------------------------------
dammit1's Profile:
http://www.excelforum.com/member.php...o&userid=16311
View this thread: http://www.excelforum.com/showthread...hreadid=277016

Try this


=ROUND(F20/10,0)*10


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=277016

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!
==============================================


"dammit1" wrote in message
...

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


--
dammit1
------------------------------------------------------------------------
dammit1's Profile:
http://www.excelforum.com/member.php...o&userid=16311
View this thread: http://www.excelforum.com/showthread...hreadid=277016

Or

=ROUNDUP(A1,-1)


"dammit1" wrote in message
...

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


--
dammit1
------------------------------------------------------------------------
dammit1's Profile:
http://www.excelforum.com/member.php...o&userid=16311
View this thread: http://www.excelforum.com/showthread...hreadid=277016