Thread
:
Nested If / And / Or ?
View Single Post
#
1
Posted to microsoft.public.excel.misc
Titian
Posts: n/a
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
Reply With Quote