The formula bar is very helpful for reviewing and editing formulas and mathematical calculations in your worksheets. The formula bar in Excel displays the value or formula of the active cell.
A formula bar in Excel is used to do mathematical calculations. The Formula Bar is located at the top of the Excel workspace like below.
Now, we will learn how to create a formula in MS Excel.
Creating formulas, step by step
Formulas always start with the equal sign "=" typed in the cell
- Select a cell
- Type the equal sign (=)
- Select a cell or type value
After pressing enter you will get 20 in the result.
Using Formulas with Cells
You can type values into cells and use them in your formulas for calculation.
Here is how to do it, step by step.
- Select the cell A3
- Type an equal sign (=) at first in the A3 cell for example.
- then, Click A1 cell
- After that click (+)
- Then click A2 Cell And Press the ENTER button
The result after hitting the enter button will be 30 like my image.
This is how you work with the formula bar in Excel.
You can make formulas with all four arithmetic operations, such as addition (+), subtraction (-), multiplication (*) and division (/).
Here are some examples:
- =10+10 gives you 20
- =10-2 gives you 8
- =10*4 gives you 40
- =10/5 gives you 5
If you are still facing any issues in MS Excel, Visit our forum https://tapgen.xyz and upload your problem to get a solution.
Thanks.
=================================