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.
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.