Find the output of the following given formula if the values in the cells are as follows: B2=120, B3=130, B4=140 B5=150, B6=160?
E3=IF(AND(B2>=B4, B2<=B5),B6,B7)
1
150
2
160
3
0
4
120
Find the output of the following given formula if the values in the cells are as follows: B2=120, B3=130, B4=140 B5=150, B6=160?
E3=IF(AND(B2>=B4, B2<=B5),B6,B7)