Previously, we have seen the formulas to check multiple columns are equal in Excel 365. Similarly, here we will show the formulas to check register balance in Excel 365. Let’s learn the new formula given below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula
- To check register balance, you have to use the following formula.
=balance-debit+credit
Syntax Explanation
- Plus operator (+) – This symbol is used to add the values.
- Minus Operator (-) – This symbol will help to subtract any two values.
Practical Examples
- For instance, you have to create a sample data in Excel.
Sample data
- To generate basic outline numbering, you need to use the following formula in formula bar.
=balance-debit+credit
Use the Formula
- Then, you have to Hit the Enter key to get the result as shown below in the cell G6.
Result in the cell G6
- Now, you need to press Ctrl+D key to get the results in all other columns.
Output
Closure
In this post, you can get some clarification about the formulas ** ** to check register balance in Excel 365. If you have any other ideas or questions , do share them with us here in the comment section below. Thank you so much for Reading!! For more updates, check out our website Geek Excel!! *And Excel Formulas *!!
Keep Reading:
Top comments (0)