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

 

[Michael M]

Hi and welcome to the Board

=IF(OR(AG6="X", AG6="N/A"),"GO","NO-GO")

 

[GopalaKrishnaJ]

Try this formula
=IF(COUNTIF(A6:AG6,"=X")+COUNTIF(A6:AG6,NA())>0,"GO","NO-GO")

 

[Michael M]

OOps.. sorry, misread the post !!

 

[Sal Paradise]

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

Excel 2003
	A	B	C	D	E	F	G	H
6	3	N/A	2	3	2	X	X	GO
7	4	5	N/A	7	6	X	1	GO
8	7	8	2	5	6	N/A	6	GO
9	0	N/A	5	3	N/A	4	9	GO
10	0	9	X	X	4	9	N/A	GO
11	6	4	7	6	X	5	9	GO
12	4	1	9	4	6	2	7	NO GO
13	8	N/A	4	2	6	0	3	GO
14	1	X	X	N/A	3	X	X	GO
15	3	6	6	3	4	2	6	NO GO
16	X	6	X	4	5	3	6	GO
17	2	2	2	6	1	4	8	NO GO
Sheet3

Cell Formulas
Range	Formula
H6	=IF(COUNTIF(A6:G6,"X")+COUNTIF(A6:G6,"N/A")>0,"GO","NO GO")

 

[el3ment]

Well, what I wanted though is if within that range (a6:ag6) even one cell doesn't have an entry of X or N/A it should apprear as "NO-GO"

 

[Sal Paradise]

Well, what I wanted though is if within that range (a6:ag6) even one cell doesn't have an entry of X or N/A it should apprear as "NO-GO"

Excel 2003
	A	B	C	D	E	F	G	H
6		X		N/A	N/A	X	N/A	NO GO
7	X	N/A	X	N/A	X	N/A	X	GO
8		N/A		X	X		X	NO GO
9	X	N/A	X		X		N/A	NO GO
10	X	X	X	N/A	N/A	N/A	X	GO
11	X	X	N/A	X	N/A	N/A	N/A	GO
12	X	N/A	N/A	X	X	X	N/A	GO
13	N/A	X	X	X	X	X	N/A	GO
14	N/A	X	N/A	N/A	N/A	N/A	X	GO
15	X	X	N/A	X	N/A	N/A	X	GO
16	N/A		X	N/A	N/A	N/A	X	NO GO
17		X		X	X	N/A		NO GO
Sheet3

Cell Formulas
Range	Formula
H6	=IF(COUNTIF(A6:G6,"X")+COUNTIF(A6:G6,"N/A")=COUNTA(A6:G6),"GO","NO GO")

 

[el3ment]

How you have your pasted sheet, that is how I would like it but the formula for some reason isn't working right when I am using it

Here is a link to the spreadsheet.
http://speedy.sh/WHEnm/tracker.xlsx
Thanks for the help by the way.

 

[el3ment]

Is it working for you?

 

[Sal Paradise]

Is it working for you?

I pasted the sheet using this:
http://www.mrexcel.com/vbaddin.shtml

I cannot download your sheet, so you will have to explain what isn't working, or wait for someone else who can download your sheet to help.