Validation problem

W

Wilfried

Hello

How can I set this validation correct : OR =(ISNUMBER(C7)),((B7<>"No")).
The cell C7 must be a number and you are not allow to enter a number is B7
is No.

Thanks in advance
 
B

Bob Phillips

=OR(ISNUMBER(C7),B7<>"No")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top