Aniruddha Chourasia
Last answered:

15 Sept 2022

 Posted on:

08 Sept 2022
1

Resolved: Doubt about Formula syntax

in Introduction to Excel / Key Excel Functions: SUM, SUMIF, SUMIFS

As instructed previously formulas are to begin with '=SUM()' sign. So, what's with =+SUM()???????

1 answers ( 1 marked as helpful)
Ned Krastev
Instructor
Posted on:

15 Sept 2022
1

Hello,
It doesn't make any difference. You can start formulas with '+' and '=' . Both symbols can be used interchangeably to tell Excel you are starting a formula.
Best,
Ned

Helpful answer

Submit an answer

related questions

Panagiotis Blatsas
0
12
Index and Match exercise tried the exact formula yet all results are N/A?
Manoj Bhaskar Pammi
0
12
Resolved: Doubt regarding Match and Index combined.
Sali Sali
1
6
Hi. Are you using some key combination to put the $ sign in your formula?
Manish Rochwani
0
4
percent variance formula showing error
Panagiotis Blatsas
0
4
In Questions 3 and 5 of the 4th chapter's Test, the suggested formula gives back N/A?
Donald Trenholm
0
4
Resolved: error message "There's a problem with this formula"
Donald Trenholm
0
4
error with formula
Emmanuel Edu
1
4
No error for last formula
Asmaa Abdulhamid
0
4
how to show the value in parentheses while it is assigned with a minus in the row formula
Nguhemen Tingir
1
4
Resolved: Formula not working
Moataz Ahmed
0
4
Resolved: Criteria Typing in the Formula
Alejandro Hasselmeyer
2
4
Resolved: Excel extending a formula down a column without me asking it to. Causes Spill error