contestada

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.

Respuesta :

pkmnmushy
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 

Otras preguntas