Excel Advanced If Functions=IF (AND(B3>50,C3>50),B3+C3,B3*C3) The IF function says if values of both cells B3 and C3 are greater than 50 then add these cells else multiply these cells. See the image given below. =IF(B4>AVERAGE(C4:C9),”cell B4>average”,””) The IF function says if value in cell B4 is greater than the average of the cells from C4 to C9 then display “cellB4>average” else leave the cell blank.
|
- Class 12
- Class 10
- Class 9
- Class 8
- Class 7
- Class 6
- Class 11
- Class (1-5)
- Other books
- Class 12
- Class 10
- Class 9
- Class 8
- Class 7
- Class 6
- Class 11
- Class (1-5)
- Other books