Sr Accountant,
This is what I came up with:
Cells A11 thru F11 blank,
In cell G11
"=IF(ISTEXT(A11)=TRUE,1,IF(ISTEXT(B11)=TRUE,2,IF(I STEXT(C11)=TRUE,3,IF(ISTEXT(D11)=TRUE,4,IF(ISTEXT( E11)=TRUE,5,IF(ISTEXT(F11)=TRUE,6,0))))))"
This looks at each cell one at a time, if there is text in it, it outputs a
corresponding number. To change the command, depending on the response. Just
change the number to the command.
hth

"Sr Accountant" wrote:

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