If you regularly use Excel, sooner or later, you will run into an Excel Formula.
A formula is an expression that operates on values in a range of cells.
you might do different things with formulas such as multiply, add, subtract, and divide.
Knowing how formulas work might not be a bad idea if you deal with numbers a lot.
After the plus symbol, add the second cell whose number you want in the equation.
Notice how the first cell selected is in blue and the second one is in red?
Press enter when you have the equation set up like in the image above.
Instead of seeing the formula, youll see the sum of the two selected cells.
If you want to get more cells involved, it’s possible for you to.
Lets say you have a list of things you oughta buy for a project.
You add the object and its price.
Add what you want the formula to do; for example, add everything.
So the formula will start looking like this =SUM.
Add an opening parenthesis and choose a range of cells.
Youll see that they will be added to the formula.
Add a closing parenthesis to finish everything up.
When you press enter, youll see the total.
Adding is one thing you could do.
These are the commands you’ve got the option to use.
Youll hear the words rows and columns a lot when using Excel.
you might spot the rows since they will have numbers.
The columns are also easy to spot since they will have letters.
Youll know where the error is since Excel will show an exclamation icon next to it.
For example, if you enter =SUM, youre going to see various similar formulas appear below.
