multiple criteria formula help

[natei6]

Hi all,

This is hard to articulate but if I can explain this correctly I'm sur
someone can help. I have a parts list for a furniture cut sheet. Colum
F is Length, Column G is Width, Column H is Quanity. The formula in th
G Column is designed to adjust the width based on a 49 inch sheet o
material. A 49 inch rip will give me five 9 inch parts. So if _X12 =
or 2 width should be 18.25, if 3 width should be 27.375... and so on u
to 4. If _X12 is greater than 5 I would like the next row (in colum
H) to = _X12/5 rounded down to the nearest multiple of 5. So if cel
_X12 = 28, the result in G105 should be 27.375, H105 should be 1, G10
would be 49(no formula) and H106 should should = 5 (28/5).
G105 Has this formula:
=MIN(MAX(18.25,9.125*SUM(_X12)),48)+(SUM(_X12)>=5). I have thi
formula in H105: =IF(SUM(_X12)<1,"",IF(SUM(_X12)<5,1,SUM(_X12)/5))
These formulas work only if _X12 is less than 6. I hope this is clea
enough, if not I will try again.

Many Many thanks in advance,

Nathan Sargean

 

[Vasant Nanavati]

What is _X12? is it a named range? What does the data in it represent?

What is =5 (28/5)?

 

[natei6]

*What is _X12? is it a named range? What does the data in i
represent?

What is =5 (28/5)?

Hi,

_X12 is what I named cell, it represents the product number of a piec
of furniture.

H106 should be 5 because 5 goes into 28, 5 times evenly.

Hope this helps.

Nathan Sargean