Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Create Formula
Hi All, Please help me by creating a simple formula to findout the percentage
differences of "current month" - "last month" automatically whenever the data is updated. Grade Year Jan Feb Mar Apr May 1 2005 2555 3488 2213 3239 Thanks, Lazia |
#2
|
|||
|
|||
math is (current month)/(prior month) - 1
If current month iis in C2 and prior in B2, then in the cell where you want the % change, type: =C2/B2-1 "Lazia" wrote: Hi All, Please help me by creating a simple formula to findout the percentage differences of "current month" - "last month" automatically whenever the data is updated. Grade Year Jan Feb Mar Apr May 1 2005 2555 3488 2213 3239 Thanks, Lazia |
#3
|
|||
|
|||
one way:
=INDEX(2:2,COUNTA(2:2))/INDEX(2:2,COUNTA(2:2)-1) - 1 Formatted as a percentage In article , "Lazia" wrote: Hi All, Please help me by creating a simple formula to findout the percentage differences of "current month" - "last month" automatically whenever the data is updated. Grade Year Jan Feb Mar Apr May 1 2005 2555 3488 2213 3239 Thanks, Lazia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a formula that would allow me to subtract from a d | New Users to Excel | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions | |||
How do I create a formula that could have two different outcomes? | Excel Worksheet Functions | |||
How do I create a multi formula IF function in Excel? | Excel Worksheet Functions |