Excel - exceed nesting levels
 

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(D43 78="BUSY",O4378,IF(D4378="DETAIL",O4378,IF(D4378=" END
OF
DUTY",O4378,IF(D4378="EQUIPMENT",O4378,IF(D4378="F UEL",O4378,IF(D4378="LIDAR
CALIBRATION",O4378,""))))))))

Excel - exceed nesting levels
 

Try:

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


"Jamie" wrote:
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(D43 78="BUSY",O4378,IF(D4378="DETAIL",O4378,IF(D4378=" END
OF
DUTY",O4378,IF(D4378="EQUIPMENT",O4378,IF(D4378="F UEL",O4378,IF(D4378="LIDAR
CALIBRATION",O4378,""))))))))

Excel - exceed nesting levels
 

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!

"Joe User" wrote:

Try:

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


"Jamie" wrote:
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(D43 78="BUSY",O4378,IF(D4378="DETAIL",O4378,IF(D4378=" END
OF
DUTY",O4378,IF(D4378="EQUIPMENT",O4378,IF(D4378="F UEL",O4378,IF(D4378="LIDAR
CALIBRATION",O4378,""))))))))