re: Excel formula question

quote:

---

How are "IF" formulas not working for you on this? Are you putting quotation marks around the text you want to see in Column A and also formatting cells in Column A as general?

---

I think I may have gotten my quotes in the wrong place. Let me try as suggested in the link and I'll report. Thx

ETA:

From the Link:

Question: In Microsoft Excel, I need a formula for the following:

IF cell A1= PRADIP then value will be 100
IF cell A1= PRAVIN then value will be 200
IF cell A1= PARTHA then value will be 300
IF cell A1= PAVAN then value will be 400
Answer: You can write an IF statement as follows:

=IF(A1="PRADIP",100,IF(A1="PRAVIN",200,IF(A1="PARTHA",300,IF(A1="PAVAN",400,""))))

My formula is this:

=IF(B2="97001",185,IF(B2="97110",48,IF(B2="97104",32,IF(B2="97010",25,IF(B2="97140",59""))))

What's my problem??