Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i calculate the percentage to compare two different years
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i calculate the percentage to compare two different years
Please use this white space to elaborate on your question. You limit the
people who can respond to your question when you use only the subject line. Do you want the percentage difference? If so, try: A1: Last year's number B1: This year's number %diff: = (b1-a1)/a1 Format as percent Regards, Fred "baba" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate # of years | Excel Worksheet Functions | |||
how to calculate a value with a percentage growth over 22 years | Excel Discussion (Misc queries) | |||
how do I calculate years between two dates | Excel Discussion (Misc queries) | |||
Need formula to figure out percentage of change for 5 years | Excel Discussion (Misc queries) | |||
Compare columns and get a percentage | New Users to Excel |