Previous Topic Next Topic

Excel formula help

Closed
elam - Sep 30, 2009 at 01:12 PM
venkat1926 Posts 1863 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 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response