How To Add A Percentage (Percent) To A Number In Excel Spreadsheet Explained
209.8 هزار بار بازدید -
پارسال
-
In this video we discuss
In this video we discuss how to add a percentage or percent to a number in an excel spreadsheet. We go through an example step by step showing the formula and process used
Transcript/notes
Let’s say that you want to add a percentage to a number, as you see here in this example, where we have a value of 100 and we want to add 20% to it and put the answer below in cell B3.
We start by left clicking on cell B3, so it is highlighted. Next, we type in the equals sign, then we left click on the cell we are adding to, in this case cell B1. Then we type in a plus sign, and then an open parenthesis, shift 9 on the keyboard. Next, we left click again on cell B1, then we type in a multiplication sign, shift 8 on the keyboard. And then we left click on the percentage, cell B2, then we type in a closed parenthesis and we hit the enter key, and we get our answer of 120.
One note, if you are getting a percentage value in the answer cell, B3, check to make sure the cell is formatted properly to general.
This will also work for percentages greater than 100%, as you see in this example.
Chapters/Timestamps
0:00 Example set up and beginning steps
0:50 Works for percentages greater than 100%
Transcript/notes
Let’s say that you want to add a percentage to a number, as you see here in this example, where we have a value of 100 and we want to add 20% to it and put the answer below in cell B3.
We start by left clicking on cell B3, so it is highlighted. Next, we type in the equals sign, then we left click on the cell we are adding to, in this case cell B1. Then we type in a plus sign, and then an open parenthesis, shift 9 on the keyboard. Next, we left click again on cell B1, then we type in a multiplication sign, shift 8 on the keyboard. And then we left click on the percentage, cell B2, then we type in a closed parenthesis and we hit the enter key, and we get our answer of 120.
One note, if you are getting a percentage value in the answer cell, B3, check to make sure the cell is formatted properly to general.
This will also work for percentages greater than 100%, as you see in this example.
Chapters/Timestamps
0:00 Example set up and beginning steps
0:50 Works for percentages greater than 100%
پارسال
در تاریخ 1401/12/02 منتشر شده
است.
209,833
بـار بازدید شده