I work on a sea going vessel and manage an Emergency Response document. My dilemma is automatically assigning a Muster location based upon data entered in a certain column.
I'm having a problem figuring out this Nested IF Statement:
Column J will either be blank (no entry), "Fire" or "HRC".
If Column J is blank, column A needs to read "STBD".
If column J has either "Fire" or "HRC" column A should read "PORT".
See attached Excel file for an example with only 3 or 4 rows.
Passing comment: This site is a God Send to those of us that need guidance from time to time. My sincere appreciation to the administrators and the people out in the world kind enough to help.
Bookmarks