| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula that calculates percentage of increase or decrease
=(B2-A2)/A2
Where A2 is your original number (12) and B2 is your new number (16) "Ration" wrote: I'm pretty new to Excel and I need a formula that calculates the percentage of increase or decrease between 2 numbers. For example if the first number is 12 and the second number is 16, this is a 33% increase over the original number (12). Is there a formula that incorporates this calculation? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| excel array formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formatting percentage signs in Excel | Excel Discussion (Misc queries) | |||
| In excel the formula bar behaves differently on different machines | Excel Discussion (Misc queries) | |||
Threaded Mode
