help with nested IF statement..

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
 
B

Bruno Campanini

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
 
Top