Validation problem

  • Thread starter Thread starter Wilfried
  • Start date Start date
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
 
=OR(ISNUMBER(C7),B7<>"No")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for tracking Nassau golf bets 9
1 VLOOKUP question 3
Excel Help to copy information from one row at a time to another sheet 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Enter date in one cell, and the week ending date [Sunday] appears inthe "W/E" cell 3
15 minutes early 5
Identifying non-returning formula (blank Cell) 9

Back
Top