[RESOLVED] Excel and nested IF's

[Spajeoly]

Use a Select case since you know which cells you're looking at... You can nest ifs in those as well as Or's.

Edited to add.....

I am thinking in VBA, but it will still work.

Select Case Range Sheet1.Range("$C$10") 'Eh, I think that's right...
 
Case "Apples"
 
Case "Plums"
 
Case "Etc."
 
End Select