You are working on your budget and have two numbers to add up in two different Excel cells. What is the formula you will use if cell A1 is 80 and cell A2 is 50?




=SUM 80+50


=[80+50]


=SUM(A1:A2) 


=ADD (80+50)

1 answer

The correct formula to use in Excel to add the values in cells A1 and A2 is:

=SUM(A1:A2)

This formula will correctly calculate the sum of the numbers in cells A1 and A2.