LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default formula with increments of 6

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 :(
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel: Round formula up in $5. increments =+(M4*1.1)+M4 Wanda M Excel Worksheet Functions 5 September 25th 07 05:56 PM
extend my formula with increments of 4 cells amoore Excel Worksheet Functions 5 April 27th 06 04:10 PM
Need formula to add increments of 0.16 seconds to time Tim Ashcom Excel Discussion (Misc queries) 2 July 19th 05 08:45 PM
How do I sum a formula and paste it in 7 cell increments? ExcelQuestionStephen Excel Discussion (Misc queries) 4 April 9th 05 07:12 AM
formula for defining axis maximum and increments Nick Turner Charts and Charting in Excel 4 March 20th 05 09:59 PM


All times are GMT +1. The time now is 01:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"