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

Attached Files

increase-decrease.xlsx (8.8 KB, 8 views)

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

Or =(% in May 22/% in May 21)-1