Do you own a company or business and want to calculate profits, losses and what are you investing more money in ? The upper and lower rules of the Excel tool will help you, you will no longer sit the old-fashioned way with a calculator a pencil and paper. But how exactly are these rules used? here we will explain you step by step. Plus, it’s a great way to replace your calculator, for example if you need to easily convert measurements.
What are Excel’s upper and lower rules?
They are an option in the home tab of the toolbar, in the Style menu with the name “conditional formatting”, this identifies the data that you placed in the cells. For example: do you want to know which expenses exceed a certain amount in your budget? The option “upper and lower rules” displays a list that will help you identify that amount .
We will concentrate on showing you the most used ones, which allow you to see the heaviest values in the “top 10 or top 10” cells.
How to use upper and lower rulers in Excel?
- Select the cells to include in the calculation.
- You should only put the cells that have the amounts to be calculated, do not include the headers .
- Then in the start bar on the right hand side are the “styles”, the first thing you will see will be “conditional formatting” press it.
- A menu of options will be displayed, press the second option that says “upper and lower rules”.
- Another list will be displayed, click on “Top 10 or Top 10”.
- Immediately, it highlights the amounts with the most value in the cells and by default it will be highlighted with, “light red fill with dark red text”.
- When you press “10 best or 10 superior”, you will see a dialog window that says in bold “apply format to cells whose range is TOP”.
- In the left part of that window, the number 10 will appear, that is the number of cells that will highlight in color as the most valuable. If you want to highlight more quantities, you can change it with the arrows next to the number 10.
- In the dialog window appears on the right hand side the option to change the color of the highlighted cells.
Done, this is how the upper and lower rules of the Excel tool are created and the correct use of them. If you want to see the lower values or in percentages follow the previous steps. Remember that for all Microsoft tools there are many ways to do the same thing, such as multiplication in an Excel sheet.
Now how can you use the Excel tool like a calculator? We assure you that it is very easy and useful, since doing your budget and calculations in the same Excel sheet, you save a lot of time and guarantee that your calculations are correct, since the tool works precisely, just like a normal calculator.
How to make formulas in Excel, step by step
It is important that you locate all the mathematical symbols on your computer, since they are something different from the ones you see on your calculator, this procedure is the same for the other formulas.
If you want to do a more complicated operation such as a root, locate and press this symbol: fx (insert) you will see it in the “formula bar”, then a dialog window will appear, the first thing you will see is “search for a function”, below This will be for you to write a definition of what you want to do, you put for example “square root” and it will give you to select options to calculate it.
- Let’s say you want to add your main income and your income from a temp job.
- Click on the cell where you want the result of that sum to appear.
- You put the equal sign (=) first, and then you put the amounts to be added as a normal sum (amount + amount)
- then you hit “Enter” on your keyboard and the result will automatically appear .
We hope this article has helped you , now you can use the upper and lower rules and do Excel accounts of any kind; from the most complicated for your company to the simple ones such as the family budget. Keep reading on our page for more articles about Excel to improve your handling of this excellent tool.