| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I get EXCEL formulas to work in Works? | Excel Worksheet Functions | |||
| Why, if I use the e-mail icon in excel it doesn't work? | Excel Discussion (Misc queries) | |||
| Assign Macro to button in Excel doesnt work Any ideas? | Excel Discussion (Misc queries) | |||
| Does Microsoft Excel work with XP | Excel Discussion (Misc queries) | |||
| Why doesn't the tools/options work in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
