Which sign we need to put in the begining formula and function
Answers
Answer:
Just like a basic formula, you need to start with the equal sign. After that, you would put the function name, then the range of cells inside parentheses, separated with a colon
Answer:
Just like a basic formula, you need to start with the equal sign. After that, you would put the function name, then the range of cells inside parentheses, separated with a colon.
Explanation:
The preferred way of starting an Excel formula uses an equals sign.
=SUM(B2:B10)
Because Excel wasn’t the first spreadsheet ever sold on personal computers, it also supports the formula beginning style of key competitors from the Eighties. If you were a Lotus 1–2–3 user, you could begin a formula with a plus or minus sign, so Excel lets you do likewise. Note that while Excel accepts your formula beginning with a plus or minus, it automatically adds an equals sign.
+SUM(B2:B10)
-SUM(B2:B10)
If you used Apple Works, you may have gotten used to starting a formula with @ in front of a function name. Excel lets you continue that habit, though it automatically removes the @ sign and adds an equals sign.
@SUM(B2:B10)
Finally, if you type text beginning with a number that can be interpreted as a formula, Excel will accept that too, though it adds the equals sign.
2+SUM(B2:B10)
8.9K views
View Upvoters
View Sharers
14
3
2
2 comments from Doug Jenkins and more
Sponsored by HP