julianmpace
New Member
- Joined
- Jun 19, 2018
- Messages
- 2
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:
[TABLE="width: 704"]
<thead style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font: inherit; vertical-align: baseline;">[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C7E0F9]#C7E0F9[/URL] "]
[TD="align: center"]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>[/TD]
[TD="align: center"]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>[/TD]
[TD="align: center"]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>[/TD]
[/TR]
</thead>[/TABLE]
[TABLE="width: 704"]
<thead style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font: inherit; vertical-align: baseline;">[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C7E0F9]#C7E0F9[/URL] "]
[TD="align: center"]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>[/TD]
[TD="align: center"]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>[/TD]
[TD="align: center"]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>[/TD]
[/TR]
</thead>[/TABLE]