| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting if value in cell is found in a named range | Excel Worksheet Functions | |||
| Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
| Applying conditional formatting to cell based on another cell's in | Excel Discussion (Misc queries) | |||
| Conditional Formatting For A Cell Other Than The One With The Form | Excel Worksheet Functions | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
