A1: =58
A2: =32
A3: =CEILING(A1,6) ... this would be 60
A4: =CEILING(A2,6) ... this would be 36
I have to admit, looking at your data and saying the overall size being 58"
x 32" since it must be in increments of 6" would change to 60" x 36", and
then taking that 60x36 (which is what the ceiling formulas will do), how you
come up with 27 1/2" x 34 1/4" I do not know. But the ceilings will convert
your 58x32 to 60x36.
--
** John C **

"ForeverH" wrote:

Hi John

where do i put the ceiling formulas

"John C" wrote:

A1: 58
A2: 32
=CEILING(A1,6)*CEILING(A2,6)
You can get the rest of your formula in there :)
--
** John C **

"ForeverH" wrote:

i am creating an work order with pricing. the overall size breaks down into
many parts of different sizes. i use square footage and linear measurments.
right now i've got all the pricing formulas figured out for each part (for
the exact sizes used), but i need the overall size to be rounded up to
increments of 6.

for example the overall size is 58" x 32"
part #5: size is 26 1/2" x 30 1/4" (calculated in sq ft)
cost of part #5 is 4.5/sqft

so the formula i'm using is =(26.5*30.25/144)*4.5

but i need the the overall size to be rounded up to the next 6" increment in
order for each part to be PRICED correct - but CAN'T change the sizes on my
work order

so part#5 needs to be priced as if the overall size is 60 x 36 (the part
size would then be 27 1/2" x 34 1/4"

help please :(