excel

[Warren]

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

[m_anoob]

hello warren

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

[JE McGimpsey]

Yes. One way:

=CEILING(A1,10)

In article <[email protected]>,
Warren <[email protected]> wrote:

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

[Gordon]

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