Trying to create a formula that will change the selected cell's text value

[el3ment]

Using Windows 7 enterprise and Excel 2007

I have been looking everywhere for the answer to my question with no success.
I am creating an employee training tracker and I am trying to create a formula that will change the selected cell's text value to 'GO' or 'NO-GO' based on input on a provided range of cells.

example. IF(a6:ag6 contains text value of either 'X' or 'N/A')=GO... SET VALUE otherwise should be 'NO-GO'
Thanks for the help

http://s16.postimage.org/vjwa7e38l/assessment.gif
ATTACHED IS A SCREENSHOT

 

[el3ment]

Tried to download the addin and loaded into excel, but not sure exactly how to use it.

The formula you provided works only if the empty cell has a space character in it as " " but will not function if the empty cell has no character in it.

 

[el3ment]

=IF(COUNTIF(B6:AG6,"X")+COUNTIF(B6:AG6,"N/A")+COUNTBLANK(B6:AG6)=COUNTA(B6:AG6),"GO","NO GO")

Adding the countblank worked, but now any character in the cell makes it a "GO" not just X or N/A

 

[Sal Paradise]

=IF(COUNTIF(B6:AG6,"X")+COUNTIF(B6:AG6,"N/A")+COUNTBLANK(B6:AG6)=COUNTA(B6:AG6),"GO","NO GO")

Adding the countblank worked, but now any character in the cell makes it a "GO" not just X or N/A

Try this:

=IF(COUNTIF(A6:AG6,"X")+COUNTIF(A6:AG6,"N/A")=COLUMNS(A6:AG6),"GO","NO GO")