I am programming a spreadsheet for work which is a defect code list sent to
customers to authorize returns.

The defect codes are 3 digit numbers that correspond to that particular
defect... here is my current formula which works well but is cut off at seven
arguments:

=IF(E3=301,"Phone Locked (PIN)",IF(E3=332,"Incorrect
Software",IF(E3=360,"Service Required",IF(E3=363,"Cannot Detect SIM
Card",IF(E3=371,"No Data Service",IF(E3=407,"Cosmetic Defect-Trackball",
IF(E3=414,"Debris/Fingerprints/Moisture Spots", IF(E3=415, "Display Lens
Scratched","N/A"))))))))

It's working very well, but I have about 35 different arguments I need to
enter.

Can anyone assist on a formula I can use? The current IF function works
great for what I need but I need more arguments.

Thanks!
Ryan Ford