View Single Post
  #2   Report Post  
Sunil Jayakumar
 
Posts: n/a
Default

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