4. In cell I4, enter a formula that uses the IF function and structured references to calculate customer sales Growth (as a %).

a. Growth can be calculated if the value in the 2015 Purchases column is greater than 0.

b. To calculate Growth (as a %), divide the value in the Growth ($) column by the value in the 2016 Purchases column.

c. If the value in the 2015 Purchases column is not greater than 0, return a value of N/A. If necessary, copy the formula you created in cell I4 to the range I5:I27.

Question

Computers and Technology

Tobias Arnold

14 January, 12:44

4. In cell I4, enter a formula that uses the IF function and structured references to calculate customer sales Growth (as a %).

a. Growth can be calculated if the value in the 2015 Purchases column is greater than 0.

b. To calculate Growth (as a %), divide the value in the Growth ($) column by the value in the 2016 Purchases column.

c. If the value in the 2015 Purchases column is not greater than 0, return a value of N/A. If necessary, copy the formula you created in cell I4 to the range I5:I27.

+4

Answers (1)

Know the Answer?

Abraham Solis · Answer 1

Remember that the IF function allows you to make logical comparisons between a value and what you expect. The "formula" that can explain the above is the following

IF (Something is True, then do something, otherwise do something else)

Based on what you need, The best and the easiest one is:

=IF ($F4>0,$H4/$G4,"N/A")

where $F4 >0 will be something that is true

where $H4/$G4 is the the do something

and where "N/A" is the otherwise do something else