Ask Question
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)
  1. 14 January, 14:02
    0
    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
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “4. In cell I4, enter a formula that uses the IF function and structured references to calculate customer sales Growth (as a %). a. Growth ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers