If, and, or statement

[jrisebo]

Got a question about if, and, or statement. For Cell A1, I want it to give me an answer based on A2. A2 will be a drop down or entry, either the value 90 or 180. A3 and A4 will be entered values.

So, how do I do a formula for "If A2=90, and A3 > 2.5 and A4 >2, then A1 =0.8, otherwise 1. but if A2 =180 and A3 > 2.5 and A4 >1, then A1 =0.8, otherwise 1"

I cant figure the if, and's, and or's to use!

Thanks

 

[Joe4]

Put this formula in cell A1:

=IF(OR(AND(A2=90,A3>2.5,A4>2),AND(A2=180,A3>2.5,A4>1)),0.8,1)

 

[etaf]

=IF( OR(AND(A2=90, A3 > 2.5, A4 >2) , AND(A2 =180 , A3 > 2.5 , A4 >1 )) , 0.8 , 1)

 

[jrisebo]

=IF( OR(AND(A2=90, A3 > 2.5, A4 >2) , AND(A2 =180 , A3 > 2.5 , A4 >1 )) , 0.8 , 1)

Perfect, thank you!

 

[etaf]

you are welcome - Joe4 also posted just before me / at same time FYI