Jerry keeps a spreadsheet of all the tools he owns. He wants to figure out
how many nails and screws he has so he knows how many more he needs to
buy to have 500 total. If the number of nails and screws is in cells B2 and B3,
what formula would he use to solve this problem?
A. The formula is EADD(B2:B3).
B. The formula is =SUM(B2:B3)-500
C. The formula is =500-SUM(B2:B3).
D. The formula is =500-ADD(B2 B3).

As because first you have to write the formula in any cell like to write the total if u want to to write in negative than it's B and If u want in positive than it's C. And see the above pictures to get it perfectly

Answer Link

Martebi Martebi · Answer 2 · 2022-05-04T10:39:33+02:00

The formula that would he use to solve this problem is the formula is =500-SUM(B2:B3).

What is an Excel Formula?

In the use of Microsoft Excel, a formula is known to be the given expression that is said to help one to be able to work on the values in a range that can be found in cells. It includes addition, subtraction and others.

Conclusively, The formula that would he use to solve this problem of Jerry concerning the spreadsheet so that he can know the total of nails and screws formula is =500-SUM(B2:B3).

Learn more about Excel from

https://brainly.com/question/19458039

#SPJ5