Re: Formatting a cell

Giganews Newsgroups
Subject: Re: Formatting a cell
Posted by:  SteveG (SteveG.27lh1m_1147269302.5774@excelforum-nospam.com)
Date: Wed, 10 May 2006

Angela,

Try

=CEILING(A1,5)

Where your value is in A1.

Does that help?

Steve

--
SteveG
------------------------------------------------------------------------
SteveG's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=7571
View this thread:http://www.excelforum.com/showthread.php?threadid=540646

Replies

In response to

Formatting a cell posted by Angela on Wed, 10 May 2006