Can someone tell me if Excel can round up to the nearest ten?

Yes. One way:

=CEILING(A1,10)

In article ,
Warren wrote:

Can someone tell me if Excel can round up to the nearest ten?

Warren wrote:
Can someone tell me if Excel can round up to the nearest ten?

PLEASE do *NOT* use a subject of "Excel" in a newsgroup dedicated
to.....*EXCEL*

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

hello warren

use ceiling(number, significance) or if u wanna have the other way
round go for
floor(#, Sig)


--
m_anoob
------------------------------------------------------------------------
m_anoob's Profile: http://www.excelforum.com/member.php...o&userid=19892
View this thread: http://www.excelforum.com/showthread...hreadid=345858