0
=(A1/B1)*100
then press Ctrl + Shift + % and the cell will be displayed as a percent
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
How do you find scientific notation on excel?
You find scientific notation in Excel under the Format - Number menu.
How do you calculate mean absolute percentage in Excel?
I assume you want to take the absolute value of a set of data, find the average and convert it to a percentage. For example, my data set is -1 -5 -3. The absolute values sum to 9, the average is 3 and presented as a percentage, it is 300%. I would put in my excel spreadsheet the numbers in a single column (let's call it a2, a3, a4) then in b2 cell, enter +abs(a2) and copy down. At the bottom of the absolute values, enter +average(b2:b4) or whatever your range is. You can use format cell option under edit to convert to %. If you use Excel 2007, you will find % icon under the home tab, on the number pane of the ribbon.
IN Trapezoidal Rule for Numerical Integration How you can find error?
in trpezoidal rule for numerical integration how you can find error
What is a chart tool on Excel?
It allows you to make charts or graphs. You will find it in the Charts section of the Insert Ribbon in Excel 2007.
How do you find the profit and loss in percentage?
The answer depends on percentage of WHAT!
Where can you find a database?
on Microsoft excel you can find a database.
Where can you find a spreadsheet?
Go to Microsoft excel sheet.
Where can you find a good pie chart?
Microsoft Excel
Where can one find a tutuorial about how to use Microsoft Excel?
One can find tutorial about how to use Microsoft Excel from Microsoft website. One can also watch the tutorial video from YouTube. YouTube is the best place to get this tutuorial.
How can one user get full Microsoft Excel help?
Microsoft Excel has a help function built into it that will search through a pre-installed FAQ to help find an answer. If you cannot find an answer there Microsoft support can answer any question you have.
Where can you find training online for Microsoft Excel macros?
You find training online for Microsoft Excel macros through Microsoft by searching their help sections. You can also find help that you may find easier to use by looking for tips from various experts on the Internet.
How to download free Microsoft word and excel?
One can get a Microsoft Excel free download from the official Microsoft download center. It is however a free download and one must pay once the trial is over. One can also download from Softonic.
Find the percentage error in rounding 3.452 to 3.5?
Percentage Error is: ~1.4% (1.39049826188%)
Where can I find free excel training online?
Microsoft offers excel demonstrations and helpful how-to's on their website www.microsoft.com
Where can you find a labeled diagram of Microsoft Excel on the Internet?
See related links for diagrams showing parts of the Excel screen for both Excel 2003 and Excel 2007.
I'm studying for a Microsoft Word and Microsoft Excel test...where do I find a question and answer study guide online?
See the related links for a good source for questions and answers about MS Excel.
Where can I find affordable Excel Training?
You can get a free Excel course at http://www.ozgrid.com/Excel/free-training/basic-index.htm or you can choose the Microsoft course at http://office.microsoft.com/en-us/training/CR061831141033.aspx. Microsoft offers Excel training for free at http://office.microsoft.com/en-us/training/CR100479681033.aspx. You can also find many Excel training videos on Youtube.com.
