Want to calculate a percentage simply and quickly? Use Excel

If you don't like math classes very much, you should be shudder to think of the word "percentage." How is the calculation really done? Who has to multiply with whom? And if I share, will it work? There are several questions that can be resolved in a fairly simple way.

Excel, known as Microsoft spreadsheet software, has a variety of formulas and functions for performing mathematical calculations - including percentage. Ufa! You can use the methods we're going to show here to see what a product's price would be after you discount, for example - which can be very helpful when buying that special Christmas gift or to check what a value would look like. Account with interest.

First of all, it is important to note that we will use some basic Excel commands, such as the "*" symbol to do multiplications. To leave the numbers typed in our currency, simply click the Excel start bar button.

Now check out the tutorials

Calculating Basic Percentages

Well, let's start with a simple calculation: what would be the percentage of a given value?

  • First, create a cell for the total amount of the value. Then create one more to enter the percentage value.
  • Now create another cell. This will serve to find out how much the percentage corresponds to.
  • Finally, click on the empty cell of the result and enter the formula: cell 1 multiplied by cell 2. Use “*” to multiply, and you're done!

Calculating Discounts

Yeah, Christmas is coming, and nothing better than buying gifts at a nice discount, right? But how much does the discount reduce from the original price of what you want? To find out, Excel helps you in a very simple way: just figure out how much of the total value equals the desired percentage and then subtract that found value from the total. Check out:

  • Let's use the same cells as the previous example. So create one cell for the total quantity and one for the percentage value.
  • The formula will now look a little different: Let's use the following formula: the cell with the total value - (cell with the total * percentage cell). Got confused? See the image to facilitate:

Calculating Additions

Let's say you needed to pay a $ 200 bill, but there were some unforeseen events, and you couldn't make the payment on time. Result: The dreaded interest appeared. How much is a 5% late fee? Find out in the tutorial below:

  • Create a table with three cells: one for the total amount, one for the penalty percentage, and one to find out what the percentage increase is.
  • Then just multiply the cell by the total value and the fine.

  • You will find out the value of the extra. Add it to the value of the bill.
  • Ready!

You can perform the sum calculation either manually or with Excel's own button. Just click on it and insert the desired cells, separating them with “;”.

Want to calculate a percentage simply and quickly? Use Excel via TecMundo