Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

Up or down blank percent

When looking at two cell values lets say D15 is current month and D16 is last month, in D17 how can I represent that this month is up or down XX%?
0
Matt Pinkston
Asked:
Matt Pinkston
1 Solution
 
barry houdiniCommented:
Try using this formula in D17

=D15/D16-1

format as %

That will give you a negative if current month is lower than last, otherwise positive

regards, barry
0
 
helpfinderCommented:
use formula =(D15/D16)-1 with that cell (D17) formated as percentage
in this case you are comparing current month to previous.

Also see my sample in 1st row, logic I used is -- previous month was 75, this is 150 what is 100% growth
sample.xlsx
0
 
Matt PinkstonAuthor Commented:
I tried the following

=IF(ISERROR(D15/D16),"",D15/D16-1)

D15 = 275,500,000
D14 = 235,200,000

I get a red 17.1 pct???
0
 
gowflowCommented:
you put in D17 this formula
=(D16-D15)/D15

make sure it is formatted with  %
gowflow
0
 
gowflowCommented:
In your example if you have
D15 = 275,500,000
D14 = 235,200,000
then in D16 you should have

=IF(ISERROR(D15/D14),"",D15/D14-1)
chk the file
gowflow
Variance.xls
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now