I am using Excel 2010. I have already created a drop-down box with selections of T-shirt sizes ranging from YXS to XXXL. Original drop-down cell in my form is B23. Named range for this drop-down is TSHIRTS.
In my order form, T-shirts are $10 for sizes YXS to AL. However, if someone selects XL, XXL, or XXXL, the corresponding dollar amount should adjust to $12. Is there a way to write an if/then statement that says if drop-down selection is XL, XXL, or XXXL, then price is $12. If not, then price is $10? - Thank you!
In my order form, T-shirts are $10 for sizes YXS to AL. However, if someone selects XL, XXL, or XXXL, the corresponding dollar amount should adjust to $12. Is there a way to write an if/then statement that says if drop-down selection is XL, XXL, or XXXL, then price is $12. If not, then price is $10? - Thank you!
