| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage Help Please
Please Help me, I am new to this and I am pulling my hair out. Can someone
please tell me what formula I need to type in to get the answer to the below: cost price plus 2.3% equals £20.50 + 2.3% = |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage Help Please
Try this:
=20.5*1.023 Resturns 20.9715 You might want to round to 2 decimal places: =ROUND(20.5*1.023,2) Returns 20.97 -- Biff Microsoft Excel MVP "Caz" wrote in message ... Please Help me, I am new to this and I am pulling my hair out. Can someone please tell me what formula I need to type in to get the answer to the below: cost price plus 2.3% equals £20.50 + 2.3% = |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| percentage | Excel Worksheet Functions | |||
| Percentage of 1s | Excel Discussion (Misc queries) | |||
| Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel | |||
| Percentage doesn't add up | Excel Discussion (Misc queries) | |||
Linear Mode
