multi validation?

  • Thread starter Thread starter ADK
  • Start date Start date
A

ADK

Is there a way to have a cell validate the following parameters:

1. Ignore blanks
2. Date greater than 1/1/07
3. "NR" value is acceptable

So far I can only do 1 & 2
 
Check your other post.
Is there a way to have a cell validate the following parameters:

1. Ignore blanks
2. Date greater than 1/1/07
3. "NR" value is acceptable

So far I can only do 1 & 2
Click to expand...
 
Is there a way to have a cell validate the following parameters:
1. Ignore blanks
2. Date greater than 1/1/07
3. "NR" value is acceptable

So far I can only do 1 & 2
Click to expand...

Select the cell or cells the validation is to apply to and then click on
Data/Validation in Excel's menu. Next, select "Custom" in the Allow drop
down and put this formula in the Formula field...

=AND(ISNUMBER(D1),OR(D1>=DATE(2007,1,1),D1="NR"))

where you will substitute the top, left cell address of your range for the
D1 that I used in the above formula. Then click OK.

One note about the formula... it will allow any number whose value is equal
to or greater than the equivalent serial value for January 1, 2007. This
means any **floating point** number between 39083 (date - 1/1/2007) and
2958465 (date - 12/31/9999) will pass the validation test.

Rick
 
The date part works but it will not accept NR

I changed D1 to the cell I was validating (Q7)

Using Excel 2000 if that matters

Any other ideas?
 
I tried resetting the newsgroup (in Outlook) but I still can not see my
other posting.

Can you transfer your post to this one?

Thanks
 
Back
Top