#1
|
|||
|
|||
increase or decrease %
hello Mentors,
could somebody please suggest how would I get the % of increasing or decreasing in attached sheet. In Tab 1 my data shows dept, % and year. for an example - Dept. Recs - May 2021 number is 115 (in %) and for the same dept number is 120 (in %) what formula should I use to show increasing or decreasing number for the same. please help. Maddy |
#2
|
||||
|
||||
In Q2 enter =(O2-C2)/C2 and pull down ( format as required)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Or =(% in May 22/% in May 21)-1
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I decrease the spacing of the title boundary. | andrewieira | Word | 10 | 03-24-2022 02:40 AM |
increase decrease image size each click | stacy14 | PowerPoint | 0 | 02-21-2018 01:05 PM |
percentage increase? | dgardner | Excel | 2 | 07-13-2011 03:04 PM |
Why the "decrease indent" doesn't affect the selected text to move???? | Jamal NUMAN | Word | 0 | 07-12-2011 04:10 PM |
Unable to decrease spacing after heading | ddexter | Word | 2 | 07-08-2011 02:31 AM |