How do i work out percentages using excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Could someone please tell me the formular to work out percentages using
Excel? For example what 20% of £1.10 was.
 
Hi Fern,

Try "=1.10*.2" (remove quotes), and formatting the cell as percentage.
You could also substitute the values above with cell references - if you
enter the percentage value as a percentage, it will pick it up correctly.

Hope this helps

Sunil Jayakumar

Fern said:
Could someone please tell me the formular to work out percentages using
Excel? For example what 20% of £1.10 was.

www.ayyoo.com/loans.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to calculate percentage for time 1
Profit & Loss Account Costs shown as a percentage of Sales 2
percentage 2
Total percentages 2
Percentages 2
Excel formula help wanted 3
IF function. 7
dates as percentages 5

Back
Top