Excel - exceed nesting levels

[Jamie]

I am trying to create an "if" formula to check cells in a particular column
for different texts, but it only lets me add 7 before getting an error that I
have exceeded the limit for nesting in the current file format. How do I
work around this?

=IF(D4378="LUNCH/OFFICER",O4378,IF(D4378="INFORMATION",O4378,IF(D4378="BUSY",O4378,IF(D4378="DETAIL",O4378,IF(D4378="END
OF
DUTY",O4378,IF(D4378="EQUIPMENT",O4378,IF(D4378="FUEL",O4378,IF(D4378="LIDAR
CALIBRATION",O4378,""))))))))

 

[Joe User]

Try:

=IF(OR(D4378={"LUNCH/OFFICER","INFORMATION",
"BUSY","DETAIL","END OF DUTY","EQUIPMENT","FUEL",
"LIDAR CALIBRATION"}),O4378,"")

 

[Jamie]

Thanks Joe. I had to delete a couple returns in between the lines in the
text below when I tried to copy and paste it but that worked beautifully.
You just saved me a ton of time!