Formatting a cell

A

Angela

I trying to figure out a way to make a cell round up to the next $5.00. So
if it is $262.33 -- > $265. I am not sure what is the best way to accomplish
this.
 
A

Angela

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?
 
A

Angela

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

CLR

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
 
S

SteveG

Angela,

You're very welcome. For myself, I agree that coming here and reading
posts and their solutions is a great way to learn. Like Chuck said,
"every day I learn something new here."


Regards,
Steve
 
Top