Question

To find the maximum value from the cell range. step by step.

Answer 1

Answer:

1- Write the formula in cell 1.

2 - = and(B2>40,B2<60), press enter on the key b board. 3- This function will returnTrue as the number 50 is greater than 40 as well as less than 60.