Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-31-2022, 12:37 AM
maddy29 maddy29 is offline increase or decrease % Windows 10 increase or decrease % Office 2013
Novice
increase or decrease %
 
Join Date: Dec 2021
Posts: 13
maddy29 is on a distinguished road
Default 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
Attached Files
File Type: xlsx increase-decrease.xlsx (8.8 KB, 8 views)
Reply With Quote
  #2  
Old 05-31-2022, 06:19 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline increase or decrease % Windows 7 64bit increase or decrease % Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,586
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

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
Reply With Quote
  #3  
Old 06-01-2022, 03:39 AM
Balge54 Balge54 is offline increase or decrease % Windows 11 increase or decrease % Office 2016
Novice
 
Join Date: Apr 2022
Posts: 6
Balge54 is on a distinguished road
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
increase or decrease % 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft