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

Previous articleExcel Area Chart: Visualizing Data Trends
Next articleExcel FORECAST.ETS.CONFINT: Confidence in Forecasting