Help with a formula - sizing - standard, medium or large

[julianmpace]

Hi, I need help working out if a product is Standard, Medium or Large size based on the length, width and height dimension with the following restrictions:

Standard <small style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: 0.8em; line-height: inherit; font-family: inherit; vertical-align: baseline;">Max dimension <= 52cm, next Max <= 33cm and Min <= 30cm</small>

Medium <small style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: 0.8em; line-height: inherit; font-family: inherit; vertical-align: baseline;">Max dimension <= 120cm, next Max <= 80cm and Min <= 80cm</small>

Large <small style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: 0.8em; line-height: inherit; font-family: inherit; vertical-align: baseline;">Max dimension > 120cm, or next Max > 80cm</small>

<thead style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font: inherit; vertical-align: baseline;">
</thead>

 

[Eric W]

Welcome to the board.

If your dimensions are in A2:C2, then try:

=IF(AND(MAX(A2:C2)<=52,MEDIAN(A2:C2)<=33,MIN(A2:C2)<=30),"Standard",IF(AND(MAX(A2:C2)<=120,MEDIAN(A2:C2)<=80),"Medium","Large"))

 

[julianmpace]

welcome to the board.

If your dimensions are in a2:c2, then try:

=if(and(max(a2:c2)<=52,median(a2:c2)<=33,min(a2:c2)<=30),"standard",if(and(max(a2:c2)<=120,median(a2:c2)<=80),"medium","large"))

thanks eric - however i get a lovely error message.

 

[Eric W]

Do you have any numbers in a2:c2 yet? We can put IFERROR around the formula to just show an empty cell when you don't have any values yet.