excel if statement for text help?

You can use this formula in G2:

=IF(COUNTIF(A2:F2,"=Yes")=5, "Yes","No")

Or, if you just want a 'blank' instead of 'No' use:

=IF(COUNTIF(A2:F2,"=Yes")=5,"Yes","")

If the only possibilities are "yes" and "no", you should consider switching to TRUE and FALSE, which can be more directly calculated:

AND(B2:F2) returns TRUE only when the entire range is also TRUE (or blank).

OR(B2:F2) returns TRUE if at least one cell is TRUE.

Scrawny and garbo's functions work fine if you must use "yes" or "no", or if there are other possibilities.

Enter this is G2 =IF(OR(B2="yes",C2="yes",D2="yes",E2="yes",F2="yes"),"yes","")

If any cell or cells between B2 and F2 have "yes" then G2 will return "yes".

IF function does not artwork for you. you have 3 circumstances and each subject has different nature. for this reason, you like one or 2 greater columns and then prepare IF function. make certain, the call of workers is a headache, try employing positions or in case you have much less workers, then use their names.

I believe what you are trying to do is possible. This link explains what the "if" statement will do, and how to build the statement you want:

http://www.personal-computer-tutor.com/if1.htm