Easy If, AND, OR question

[jeffalex2]

Can you nest them like this?:

=IF(AND(A1=2,B1=2,OR(C1=1,D1=1)),A1+B1,0)

In other words,

A1=2
B1=2
C1=0
D1=1

...would return 4

just didn't know if you can nest the OR within the AND and vise versa...

Thanks!

 

[CharlesChuckieCharles]

Not a question then?

 

[Aladin Akyurek]

Can you nest them like this?:

=IF(AND(A1=2,B1=2,OR(C1=1,D1=1)),A1+B1,0)

In other words,

A1=2
B1=2
C1=0
D1=1

...would return 4

just didn't know if you can nest the OR within the AND and vise versa...

Thanks!

Care to describe the procedure/the reasonig behind 4 as result given those values in A1:D1? Please don't use formulas or functions in your answer...

 

[Weaver]

Yes, you can.

 

[jeffalex2]

Cool...thanks Weaver!

The formula is used for estimating quantities based on data gathered through userforms and located on other sheets. I've set it up and it's working great.