formula trouble

  • Thread starter Thread starter redforest
  • Start date Start date
R

redforest

Hi

I have a created a worksheet and within it I want to change a text cell
value to a corresponding number value. There are 22 different 'text'
scenarios with different number values. For example if a cell contains
the entry "P1" then the value given would be 1, or if the entry was
"P2(ii)" then the value would be 2.5 etc. I am able to do the first 7
text(s) successfully using the IF command but then recieve an error
(formula length, I think). Here is the formula that works . . .
=IF(W8="P1",1,IF(W8="P1(i)",1,
IF(W8="P1(ii)",1.5,IF(W8="P2",2,IF(W8="P2(i)",2,IF(W8="P2(ii)",2.5,IF(W8="P3",3,"F")))))))
Unfortunately I don't know how to make it work to accept all of my
text values.

Can anyone please help

R
 
see response in public.excel

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Back
Top