Data Validation

[Bill Leslie]

I need validation in cell D4 that would only permit an
entry if cell I4 is blank and the entry in D4 must be 3 or
less. I tried the following but it does not limit the
value to 3 or less.

=ISBLANK(I4)*(D4<=3)

Thanks

Bill

 

[Peo Sjoblom]

=AND($I$4="",$D$4<=3)

 

[Jim]

Data>Validation>Settings>Custom>
=AND(I4="",D4<=3)
uncheck the Ignore Blanks checkbox