subject

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.

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 17:00
Annie is creating a corporate report for a company’s annual meeting. in the report, she wants to add the signature of various department heads. which device can annie use to capture signatures to include in the report? a. printer b. monitor c. e-reader d. digitizing tablet
Answers: 1
question
Computers and Technology, 22.06.2019 23:00
Which type of tab stop is most for weights and measurements?
Answers: 1
question
Computers and Technology, 23.06.2019 04:20
Which network media uses different regions of the electromagnetic spectrum to transmit signals through air? uses different regions of the electromagnetic spectrum to transmit signals through air.
Answers: 2
question
Computers and Technology, 23.06.2019 15:00
Jake really works well with numbers and is skilled with computers but doesn't work well with others. which of the jobs discussed in this unit might be best for jake? why?
Answers: 3
You know the right answer?
4. in cell i4, enter a formula that uses the if function and structured references to calculate cust...
Questions
question
Mathematics, 06.04.2020 01:03
question
Mathematics, 06.04.2020 01:03
question
History, 06.04.2020 01:03
question
Mathematics, 06.04.2020 01:03
question
Geography, 06.04.2020 01:03
Questions on the website: 13722367