View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anniem Anniem is offline
external usenet poster
 
Posts: 11
Default If/And Greater than or Less Than

Hi and thanks again for any suggestions forthcoming,

Deadlines are looming and I was hoping someone could help with a formula
that goes something like:

If A1=XXX, And A2 =1, And A2<=10, do nothing. If A1= YYY, And A2=5, And
A2<=10, do nothing. (etc) If False, Message Box. There are 4 sets of
conditions to test for.

Thanks,