Validation
 

I have this formula in a data valadation: =C9=Yes

This won't allow any entry into this cell but "Yes".

I would like a formula that would allow a "Yes" or a "No".
--
Thanks
Shawn

Use the List function and add Yes and No to that list.

--
HTH

Bob Phillips

"Shawn" wrote in message
...
I have this formula in a data valadation: =C9=Yes

This won't allow any entry into this cell but "Yes".

I would like a formula that would allow a "Yes" or a "No".
--
Thanks
Shawn

Try...

=(C9="Yes")+(C9="No")

Hope this helps!

In article ,
"Shawn" wrote:

I have this formula in a data valadation: =C9=Yes

This won't allow any entry into this cell but "Yes".

I would like a formula that would allow a "Yes" or a "No".

Try

=OR($C$9="Yes",$C$9="No")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Shawn" wrote in message
...
I have this formula in a data valadation: =C9=Yes

This won't allow any entry into this cell but "Yes".

I would like a formula that would allow a "Yes" or a "No".
--
Thanks
Shawn