Please tell me about the formulas used in Ms excel.
(All formulas with sign before and after)
please don't answer wrong!!!
Answers
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.