software

Column D is a dropdown list of shirt sizes from S to 4X.
I am trying to get the price to show up in Column F, depending on what size
appears in Column D. S through XL shirts are 17.75 and 2X through 4X shirts
are 19.75. I got this formula to work for one size only:
=IF(D4=quot;Squot;,17.75,19.75)Try this:

=IF(OR(D4={quot;Squot;,quot;Mquot;,quot;Lquot;,quot;XLquot;}),17.75,IF(OR(D4={quot;2Xquot; ,quot;3Xquot;,quot;4Xquot;}),19.75,quot;quot;))

HTH,
Elkarquot;Brianquot; wrote:

gt; Column D is a dropdown list of shirt sizes from S to 4X.
gt; I am trying to get the price to show up in Column F, depending on what size
gt; appears in Column D. S through XL shirts are 17.75 and 2X through 4X shirts
gt; are 19.75. I got this formula to work for one size only:
gt; =IF(D4=quot;Squot;,17.75,19.75)
gt;

Everything shows up as 17.75
quot;Elkarquot; wrote:

gt; Try this:
gt;
gt; =IF(OR(D4={quot;Squot;,quot;Mquot;,quot;Lquot;,quot;XLquot;}),17.75,IF(OR(D4={quot;2Xquot; ,quot;3Xquot;,quot;4Xquot;}),19.75,quot;quot;))
gt;
gt; HTH,
gt; Elkar
gt;
gt;
gt; quot;Brianquot; wrote:
gt;
gt; gt; Column D is a dropdown list of shirt sizes from S to 4X.
gt; gt; I am trying to get the price to show up in Column F, depending on what size
gt; gt; appears in Column D. S through XL shirts are 17.75 and 2X through 4X shirts
gt; gt; are 19.75. I got this formula to work for one size only:
gt; gt; =IF(D4=quot;Squot;,17.75,19.75)
gt; gt;

it works great! THANKS!

quot;Elkarquot; wrote:

gt; Try this:
gt;
gt; =IF(OR(D4={quot;Squot;,quot;Mquot;,quot;Lquot;,quot;XLquot;}),17.75,IF(OR(D4={quot;2Xquot; ,quot;3Xquot;,quot;4Xquot;}),19.75,quot;quot;))
gt;
gt; HTH,
gt; Elkar
gt;
gt;
gt; quot;Brianquot; wrote:
gt;
gt; gt; Column D is a dropdown list of shirt sizes from S to 4X.
gt; gt; I am trying to get the price to show up in Column F, depending on what size
gt; gt; appears in Column D. S through XL shirts are 17.75 and 2X through 4X shirts
gt; gt; are 19.75. I got this formula to work for one size only:
gt; gt; =IF(D4=quot;Squot;,17.75,19.75)
gt; gt;

Hi

=17.75 ISNUMBER(MATCH(D4,{quot;2Xquot;;quot;3Xquot;;quot;4Xquot;},0))*2

Arvi Laanemetsquot;Brianquot; gt; wrote in message
...
gt; Column D is a dropdown list of shirt sizes from S to 4X.
gt; I am trying to get the price to show up in Column F, depending on what
size
gt; appears in Column D. S through XL shirts are 17.75 and 2X through 4X
shirts
gt; are 19.75. I got this formula to work for one size only:
gt; =IF(D4=quot;Squot;,17.75,19.75)
gt;
Works great...Thanks

quot;Arvi Laanemetsquot; wrote:

gt; Hi
gt;
gt; =17.75 ISNUMBER(MATCH(D4,{quot;2Xquot;;quot;3Xquot;;quot;4Xquot;},0))*2
gt;
gt; Arvi Laanemets
gt;
gt;
gt; quot;Brianquot; gt; wrote in message
gt; ...
gt; gt; Column D is a dropdown list of shirt sizes from S to 4X.
gt; gt; I am trying to get the price to show up in Column F, depending on what
gt; size
gt; gt; appears in Column D. S through XL shirts are 17.75 and 2X through 4X
gt; shirts
gt; gt; are 19.75. I got this formula to work for one size only:
gt; gt; =IF(D4=quot;Squot;,17.75,19.75)
gt; gt;
gt;
gt;
gt;