Formatting a cell
 

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.

Formatting a cell
 

=CEILING(A1,5)

Vaya con Dios,
Chuck, CABGx3



"Angela" wrote:

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.

Formatting a cell
 

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

Formatting a cell
 

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

Formatting a cell
 

Angela,

In B15 use,

=CEILING(SUM(B14*F3),5)

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=540646

Formatting a cell
 

=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

Formatting a cell
 

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

Formatting a cell
 

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

Formatting a cell
 

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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=540646