Javatpoint Logo
Javatpoint Logo

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.

Excel Advanced If Function 1

=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.

Excel Advanced If Function 2
Next TopicExcel Macros




Please Share

facebook twitter google plus pinterest tumbler

Latest 4 Tutorials