View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Titian
 
Posts: n/a
Default Nested If / And / Or ?

Greetings

Is there any way the following can be expressed in single formula?

If A2 = 1 and B2 <= 10 - "Yes"

If A2 = 1 and B2 10 - "No"

If A2 = 2 and B2 <= 20 - "Yes"

If A2 = 2 and B2 20 - "No"

Thanks in advance.



Dan