You''re welcome.........you can buy books, but I recommend just coming here
and reading other peoples posts and the corresponding answers.....some you
will understand, some you will not........but soon you will be trying to
figure out the answers before you read the responses.....and you can always
ask your own questions just like you did here..........every day I learn
"something" new here.....

Vaya con Dios,
Chuck, CABGx3



"Angela" wrote:

Thank you both so much. Where do you learn this from? I would like to
become more proficent at excel.

"CLR" wrote:

=CEILING(B14*F3,5)

Vaya con Dios,
Chuck, CABGx3



"Angela" wrote:

Yes, but I have an existing formula. I should have said that from the start.

In the cell B15 ** =SUM(B14)*F3. ** B15 is the cell that i want to round
up. So how do I type that?

"SteveG" wrote:


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...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=540646