I am trying to write an if statement for a range of cells, so that if any one
of the 6 cells has a certain word in them, my destination cell (where my
formula is written), will give my staff members a certain command. Is there
a way to do this with an 'if' statement, or does anyone have other
suggestions?

Any help you can give me would be much appreciated. Thank you in advance.
Shelli - Senior Accountant