I am building a data entry form and cannot get a validation to work.
What i need is this,
If either c59 or c60 contain an X, do not allow any entry in c61,
and it c59 or c60 DO NOT contain an X then allow ONLY an X in c61
Thanks Steve
I am building a data entry form and cannot get a validation to work.
What i need is this,
If either c59 or c60 contain an X, do not allow any entry in c61,
and it c59 or c60 DO NOT contain an X then allow ONLY an X in c61
Thanks Steve
Try this:
In E58, insert this formula:
=IF(COUNTIF(C59:C60,"x"),,"no")
Now in Validation, select "Custom", and insert:
=AND(E58="no",C61="x")
HTH
Jason
Atlanta, GA
>-----Original Message-----
>I am building a data entry form and cannot get a
validation to work.
>What i need is this,
>
>If either c59 or c60 contain an X, do not allow any
entry in c61,
>and it c59 or c60 DO NOT contain an X then allow ONLY an
X in c61
>
>Thanks Steve
>.
>
Thanks Jason ! Your solution worked.
I was in Atlanta last week and besides it being COLD it was great ! (CNN
Center, Underground, World of Coca Cola)
Thanks, Steve (Napa Valley, California)
"Jason Morin" wrote:
> Try this:
>
> In E58, insert this formula:
>
> =IF(COUNTIF(C59:C60,"x"),,"no")
>
> Now in Validation, select "Custom", and insert:
>
> =AND(E58="no",C61="x")
>
> HTH
> Jason
> Atlanta, GA
>
>
> >-----Original Message-----
> >I am building a data entry form and cannot get a
> validation to work.
> >What i need is this,
> >
> >If either c59 or c60 contain an X, do not allow any
> entry in c61,
> >and it c59 or c60 DO NOT contain an X then allow ONLY an
> X in c61
> >
> >Thanks Steve
> >.
> >
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks