0
Enter the percent in one column, enter the other value in another column.
In a third column tell excell to multiply the 2 columns and divide by 100.
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
How do you work out percentage depreciation?
the new number divided by the old nuumber e.g If the new price is : £56 and the original price : £80 the percentage depreciation is: 56 / 80 = 0.7 ( the percentage decrease)
If the office has 150 employees and 30 of the employees work the night shift. What percentage of the employees work the night shift?
20% of them
How do you find the percentage on Excel?
You find percentages with excel the same why you would with any other method. Multiply the number times the decimal equivalent of the percent. If you want to find 12% of $132.56, use this formula: =132.56*.12If you store the number in cell A1 and the percent in A2, you can use the following formula to calculate the results: =A1*A2
Can I get training for Excel Basics online?
There are numerous companies offering excel training online. You can also obtain excel training from Microsofts website for free.
How do i work out a percentage difference between 2 numbers?
Turn them into a fraction and then multiply it by 100
What is the function of percentage in micro-soft Excel?
functions of excel
How do you add a percentage in excel?
Multiply by 0.01.
What would be the percentage between 5.10 from 4.25?
what is the formula in excel for: 5.10 percentage 4.25
How can you use Excel at home and at work?
go on to Microsoft excel and do what you want
How do you Excel at work?
By working hard and knowing your job well and becoming really proficient at doing it, then you will excel at work.
How can you add percentage to all numbers in same column on excel?
Get an accountant
'How do you do formulas on Excel and continue to work with answer as a numerical value and not a formula '?
'How do you do formulas on excel and continue to work with answer as a numerical value and not a formula '
How do Microsoft Word Excel and PowerPoint support the work force?
AS computer is very important for us .like the same way Excel AND PowerPoint helps us a lot Excel help us for calculations like taking out averages , percentage,addition subtraction e.t.c , and PowerPoint helps us to make presentation on multifarious topics
What is instruts excel to display a value as a percentage by multiplying by 100 and rounding?
use format, under numbers select percentage
What is Work Book in MS Excel?
A workbook is a file created by excel spreadsheet application
What is subtotal percentage formula field?
Are you asking about something in Excel? Can you give example?
Can you use Excel 2010 as Excel 2007?
The differences between them are not extensive so you can work in Excel 2010 easily if you are familiar with Excel 2007. You can save your files so that Excel 2007 will recognise them.
