If Forumla adjustment

[pauldaddyadams]

Hi,

I have the following IF statement however I need to amend it - each time I do I get #Value

=IF(OR(ISBLANK(F2),ISNUMBER(SEARCH("Lam",F2)),(ISNUMBER(SEARCH("Lam",I2)))), "Annealed",IF(OR(CODE(RIGHT(F2,1))=84,CODE(RIGHT(I2,1))=84),"Toughened","Annealed"))

I need it amending so if F2 IS BLANK then it displays "Toughened"

I tried deleting the first logial1 arguement and adding a new if but kept getting an error. Any suggestions? Even if its to delete the "ISBLANK(F2)" part

[arthurbr]

Perhaps

Please Login or Register  to view this content.

[JBeaucaire]

Maybe:

=IF(OR(ISNUMBER(SEARCH("Lam",F2)),ISNUMBER(SEARCH("Lam",I2))), "Annealed", IF(OR(ISBLANK(F2),CODE(RIGHT(F2,1))=84,CODE(RIGHT(I2,1))=84),"Toughened","Annealed"))

[pauldaddyadams]

=IF(ISBLANK(F2),"Toughened",IF(OR(ISNUMBER(SEARCH("Lam",F2)),(ISNUMBER(SEARCH("Lam",I2)))),"Annealed",IF(OR(CODE(RIGHT(F2,1))=84,CODE(RIGHT(I2,1))=84),"Toughened","Annealed")))

Done it! Ignore this post