Formatting a cell

[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.

[SteveG]

Angela,

Try

=CEILING(A1,5)

Where your value is in A1.

Does that help?

Steve

[CLR]

=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.

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

"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
>
>

[SteveG]

Angela,

In B15 use,

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

HTH

Steve

[CLR]

=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
> >
> >

[Angela]

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

[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



"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
> > > >
> > > >

[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