Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use the ceiling function
What I am attempting to do is multiply each cell in D column by 6 and then
rounding up the answer to a multiple of either .25, .50, .75, or up to the next whole dollar amount. But I want it to do it on each row. I am using the excel template for inventory.and so far I got the =D1*6 but I don't know how to use the ceiling function or to get it to do the same calculation for each row. I'm sure this is pretty basic but I am just beginning to really use my PC for more than a paper weight. -- Thank You for all your help, Larry |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use the ceiling function
Try this:
Use column E as helper column. Enter this formula in E1: =CEILING(D1*6,0.25) Copy down as needed. Biff "Larry" wrote in message ... What I am attempting to do is multiply each cell in D column by 6 and then rounding up the answer to a multiple of either .25, .50, .75, or up to the next whole dollar amount. But I want it to do it on each row. I am using the excel template for inventory.and so far I got the =D1*6 but I don't know how to use the ceiling function or to get it to do the same calculation for each row. I'm sure this is pretty basic but I am just beginning to really use my PC for more than a paper weight. -- Thank You for all your help, Larry |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use the ceiling function
Larry,
CEILING always rounds up. If you just want to round to the closest .25 (either up or down) us MROUND. Your formula should look something like this: =MROUND(D1*6,.25) Keep in mind that MROUND is a funcion in the Analysis ToolPak add-in. You will need to make sure that this add-in is loaded in order to use this function. Hope this helps, Conan Kelly "Larry" wrote in message ... What I am attempting to do is multiply each cell in D column by 6 and then rounding up the answer to a multiple of either .25, .50, .75, or up to the next whole dollar amount. But I want it to do it on each row. I am using the excel template for inventory.and so far I got the =D1*6 but I don't know how to use the ceiling function or to get it to do the same calculation for each row. I'm sure this is pretty basic but I am just beginning to really use my PC for more than a paper weight. -- Thank You for all your help, Larry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Roundup or Ceiling Function to round to a specific number | Excel Discussion (Misc queries) | |||
Cumulative sum with a ceiling | Excel Worksheet Functions | |||
Round/Ceiling on an IF function returning numerical value or text | Excel Worksheet Functions | |||
Max, Ceiling, If, Etc | Excel Discussion (Misc queries) | |||
Something like CEILING or FLOOR | Excel Worksheet Functions |