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

=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
Next TopicExcel Macros

Youtube For Videos Join Our Youtube Channel: Join Now


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA