subject
Mathematics, 19.08.2021 15:50 Jackiecroce12

In cell K10, create a formula using the SUM function that calculates the total of the range F17:F20, subtracts it from the value in cell J10, adds the total of the range G17:G20, and subtracts 160. I would like to know the correct entry of the formula.
---
One such entry that I have tried is:
=(J10-SUM(F17:F20))+160-G17:G20
or
=(J10-SUM(F17:F20))+G17:G20-160
or
=(J10-SUM(F17:F20))+(160-G17:G20) or
=(J10-SUM(F17:F20))+(G17:G20-160) and countless others.
---
If you could help, that would be much appreciated!

ansver
Answers: 3

Another question on Mathematics

question
Mathematics, 21.06.2019 23:00
Which of the following scenarios demonstrates an exponential decay
Answers: 1
question
Mathematics, 21.06.2019 23:20
Find the common ratio of the sequence. -4, 8, -16, 32, a: -12b: -2c: 12d: -1/-2
Answers: 1
question
Mathematics, 22.06.2019 00:30
The scatter plot shows the number of animal cells clara examined in a laboratory in different months: plot ordered pairs 1, 20 and 2, 60 and 3,100 and 4, 140 and 5, 180 what is the approximate predicted number of animal cells clara examined in the 9th month?
Answers: 3
question
Mathematics, 22.06.2019 01:40
The graph below shows the line of best fit for data collected on the number of cell phones in cell phone cases sold at the local electronic store on four different days
Answers: 3
You know the right answer?
In cell K10, create a formula using the SUM function that calculates the total of the range F17:F20,...
Questions
question
Mathematics, 11.05.2021 17:50
question
English, 11.05.2021 17:50
question
Mathematics, 11.05.2021 17:50
question
Mathematics, 11.05.2021 17:50
Questions on the website: 13722359