Search : in
By :

Excel formula help

Last answer on Oct 1, 2009 2:00:35 am BST elam, on Sep 30, 2009 6:12:04 pm BST 
 Report this message to moderators

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

Configuration: Windows XP Internet Explorer 8.0

Best answers for « Excel formula help » in :
[Excel] – Countif Formula Show[Excel] – Countif Formula Issue Solution Note Issue I have one excel file in that Column "B" has the "pending or Closed" Status and Column "C" has "Severity 1, Severity 2 and Severity 3" I want to count in one cell with "Pending...
[Excel]changing cell formula to text Show[Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...

1

 venkat1926, on Oct 1, 2009 2:00:35 am BST

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)

Reply to venkat1926