Open a blank Excel workbook. Enter the following values:
B7 = 15
K6 = 50
H7 = 25
Write an IF function to be placed in cell G7 that assigns the value of cell B7 to cell G7 if the value in cell K6 is greater than the value in cell H7; otherwise, hold the IF function assign nil (0) to cell G7.
Answers: SAME AS ABOVE
=IF(K6>H7,B7,0)
I get 15 within G7 using that formula
Type this in G7:
=IF(K6>H7,B7,0)
Simple as that.