ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do i work out percentages using excel? (https://www.excelbanter.com/excel-discussion-misc-queries/21568-how-do-i-work-out-percentages-using-excel.html)

Fern

How do i work out percentages using excel?
 
Could someone please tell me the formular to work out percentages using
Excel? For example what 20% of £1.10 was.

Sunil Jayakumar

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" wrote in message
...
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




All times are GMT +1. The time now is 03:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com