Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

What, if anything, is wrong with using the formula -SUM(A2+B2+C2) in cell D2 in order to compute the sum of the numbers in row 2?

image text in transcribed

What, if anything, is wrong with using the formula -SUM(A2+B2+C2) in cell D2 in order to compute the sum of the numbers in row 2? fx -SUM(A2+B2+C2) D2 C E 1 |=SUM(A2+B2+C2) 2 12 15 |18 3 4 It is an error. The SUM function requires 2 or more arguments. =SUM(A2+B2+C2) has just one argument. O It will work, but it's not the most efficient. If you want to use the SUM function you should use -SUM(A2:C2). If you want to add the numbers individually, you should use =A2+ B2+C2. When you use SUM(A2+B2+C2), Excel adds the three numbers and passes the result to the function SUM which returns the result you passed it. Nothing. SUM(A2+B2+C2) is the best formula for computing the sum of the numbers in row 2 You should use absolute rather than relative cell references

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions