formula trouble

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
 
B

Bob Phillips

see response in public.excel

--

HTH

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula error!! 4
Multiple options with multiple ranges 2
Need help with a formula 4
Formula 3
Copying formulas in range and pasting in a selection 3
Transparently updating another workbook from the current workbook 3
UDF returns #NUM! with F9 or Application.CalculateFull if sheet notactive 11
look to do an Offset of something like a offset 2

Top