Returning only specific values

[RoydenC]

I have 2 columns A and B containing either numbers ( when a decision has been reached), or a "?" ( when a decision is required)
How do I write or format column C to indicate only when the "?" appears in either column A and/or column B?

 

[maxflia10]

Royden,

What would you like to do with column C? Format how?

 

[RoydenC]

"format" is incorrect-my apologies
Column C should simply reflect what is in columns A or B, but ONLY if it contains "?" -ie Coulmn C should NOT show numbers that are in Columns A or B ( refer to my original post- but ignore the format idea)
Thanks
Royden

 

[blahblah]

You can use the IF function to return a text command in column C

 

[Ian Mac]

Hello,

does the following meet your requirement:

Transpose Access Data Help.xls
	E	F	G	H
142	A	B	Test
143	?	2	YES
144	?	3	YES
145	6	4
146	8	41
147	6	?	YES
Sheet2

 

[RoydenC]

Thanks so much,
this works fine
Royden