In this post,MiniTool Softwarewill introduce some basic, useful, and popular Excel formulas.
We will also show you how to use them in Microsoft Excel.
What Is Excel Formula?
Microsoft Excel is a spreadsheet developed by Microsoft.
Microsoft Excel has more functions than you know, and these features are also much more powerful.
For example, you’ve got the option to use formulas in Excel to perform calculations.
In this post, we will introduce some most used Excel formulas you may use.
We will also show you how to use formulas in Microsoft Excel.
Do you know how to merge or unmerge cells in Excel without losing data?
In this article, we will show you some useful guides.
How to Create a Formula that Refers to Values in other Cells?
Step 2: throw in the equal sign=into that cell.
Formulas in Excel always start with the equal sign.
Step 3: Select a cell or throw in the address of that cell into the selected cell.
The address of a cell in Excel is the row number and the column number of that cell.
Step 5: grab the next cell, or jot down the address into the selected cell.
Step 6: PressEnter.
Then, you’re free to see the calculation result in the selected cell with the formula.
To Subtract, snag the destination cell, pop in =cell 1-cell 2, then pressEnter.
To Multiply, choose the destination cell, jot down =cell1*cell2, then pressEnter.
To Divide, go for the destination cell, jot down =cell 1/cell 2, then pressEnter.
To Power, snag the destination cell, throw in =cell 1^cell 2, then pressEnter.
The data in the destination cell is with a formula.
you should probably paste values in another cell.
How to See a Formula in Excel?
It is easy to do this.
You just need to click that cell and see the formula in the formula bar.
On the other hand, you might also double-click into that cell and see the formula in that cell.
These features have a lot in common.
They have the same purpose: to calculate and solve problems for you.
you’re free to also enter a formula that contains a built-in function in Excel.
Here is how to do this:
Step 1: Select an empty cell as the destination cell.
Step 2: jot down an equal sign=and then jot down a function.
For example, if you want to get the sum of the data, you oughta jot down =SUM.
Step 3: bang out an opening parenthesis (.
Step 4: pick the range of cells you want to calculate.
Step 5: punch in a closing parenthesis ).
Step 6: Press Enter, then you will see the result.
Here, we will introduce the parts of an Excel formula.
How to Delete or Remove a Formula?
Here are two main situations:
We will introduce these two situations in this part.
How to Delete a Formula but Keep the Results?
Step 2: Paste in the same cell by using thePaste Valuesoption.
you might use these steps to do this:
Step 2: Under theHometab, click theCopybutton in theClipboardgroup.
Step 3: Under theHometab, go for the arrow below thePastebutton image in theClipboardgroup, then selectPaste Values.
How to Delete an Array Formula?
Here are the steps you gotta use:
Step 1: Click a cell in the array formula.
Step 2: Under theHometab, clickFind & Selectin theEditinggroup, then clickGo To.
Step 3: Click theSpecialbutton.
Step 4: SelectCurrent array.
Step 5: PressDELETE.
How to Recover Your Lost or Deleted Excel Files on Windows and Mac?
If your important files are missing due to some reason, do you know how to get them back?
With it, you could recover your files from your data storage devices in different situations.
MiniTool Power Data Recovery has a free edition.
you’ve got the option to tap the following button to get this freeware.
This software will show all drives it can detect.
Then, click theOKbutton to save the prefs.
Step 4: When the scanning process ends, you will see the scan results.
opt for files you want to recover.
Step 5: Choose your needed files, then poke the Save button.
Step 6: TheSelect a directory to save filesinterface will pop up.
it’s possible for you to select a suitable location to back up your selected files.
you might pick up a proper edition from the MiniTool official site.
Likewise, this software can recover all kinds of files for you.
It has a trial edition.
If you decide to use it to recover files, it’s crucial that you use a full edition.
you’ve got the option to also get one from MiniTool.
See how to use this software torecover data on Mac.
Wrap Things up
Dont know how to use formulas in Excel?
This article shows you some relative information.
We hope the contents mentioned here can help you.
