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.