Data Validation

  • Thread starter Thread starter Bill Leslie
  • Start date Start date
B

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
 
Back
Top