Which Excel formula subtracts the value in one cell from another?

Which Excel formula subtracts the value in one cell from another?

• A. =A1+B1
• B. =A1-B1
• C. =A1/B1
• D. =SUM(A1,B1)

Answer: (B)

Subtraction in Excel is done with the minus sign, and the formula A1-B1 takes the value in A1 and subtracts the value in B1 from it. That’s why it returns the difference between the two cells. For example, if A1 has 10 and B1 has 3, A1-B1 yields 7. The other options perform addition, division, or summation, not subtraction: A1+B1 adds the values, A1/B1 divides A1 by B1, and SUM(A1,B1) adds them as well (but without subtracting). If you need the absolute difference, you’d use ABS(A1-B1), but for simply subtracting one cell from another, A1-B1 is the correct approach.

Subtraction in Excel is done with the minus sign, and the formula A1-B1 takes the value in A1 and subtracts the value in B1 from it. That’s why it returns the difference between the two cells. For example, if A1 has 10 and B1 has 3, A1-B1 yields 7. The other options perform addition, division, or summation, not subtraction: A1+B1 adds the values, A1/B1 divides A1 by B1, and SUM(A1,B1) adds them as well (but without subtracting). If you need the absolute difference, you’d use ABS(A1-B1), but for simply subtracting one cell from another, A1-B1 is the correct approach.