View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Linda B Linda B is offline
external usenet poster
 
Posts: 3
Default Data Validation with IF Function and Multiple Min/Max Values

Hi,
I have a spreadsheet with Data Validation in Column M showing List A through
H.
Example: Cell M3 can either be null or have value A, B, C etc thru H

I need to validate in Cell O3, based upon what they did in cell M3. Here's
an example:
If M3 is null, then O3 can either be zero (0) or can have value with min
= .01 and max = .04. User is not allowed to enter anything 0 and <.01, but
we want to allow them to enter 0.

If M3 is not null (user selected from list A thru H), then min = 0 and
max = 0.

Thanks for any help. I've tried a variety of statements with IF/OR and
nothing has worked so far.

Thanks for any assistance,
Linda