help with nested IF statement..

  • Thread starter Thread starter simon.steel
  • Start date Start date
S

simon.steel

I think I need a nested IF statment to deal with the following.

if value in K8 is "Non Asbestos" then C15 = 0
if value in K8 is "Chrysotile" then C15 = 1
if value in K8 is "Amosite" OR Amosite Chrysotile" then C15 = 2
if value in K8 is "Crocidolite then C15 = 3

How can I make this formula??

SS
 
I think I need a nested IF statment to deal with the following.

if value in K8 is "Non Asbestos" then C15 = 0
if value in K8 is "Chrysotile" then C15 = 1
if value in K8 is "Amosite" OR Amosite Chrysotile" then C15 = 2
if value in K8 is "Crocidolite then C15 = 3

How can I make this formula??
Click to expand...

Put in C15:
=IF(K8="Non Asbestos",0,IF(K8="Chrysotile",1,IF(OR(K8=
"Amosite",K8="Amosite Chrysotile"),2,IF(K8="Crocidolite",3,0))))

Bruno
 
You must log in or register to reply here.

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

nested datevalue if and statements 5
IF with and OR 2
Conditional Formatting Using Min/Max 10
"IF THEN" FORMULAS 3
Excel Formula for Eclipsing Circles 0
DateRange Lookup no exact match, can't use lesser 4
AVERAGE NUMBER IN COLUMN PROBLEM 1
Using formulas from Quattro Pro in Excel 2007 4

Back
Top