Excel formula help

Closed
elam - Sep 30, 2009 at 01:12 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 30, 2009 at 09:00 PM
I am needing the formula for pulling from an excel list to provide a cost amount.

I have a list that includes med-xxx large shirts and need formula that shows if they select med-x large shirts then the cost in adjacent cell is $5.50 and if they select xx-xxx large then the cost is $6.50.

Thanks

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Sep 30, 2009 at 09:00 PM
assume there are only two alternatives
med-xxx large
xx-xxx large

then suppose the data is to be entered in column A1 then in B1 copy this formula
=if(a1="med-xxx large",5.50,6.50)
0