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%?
Matt PinkstonAsked:
Who is Participating?
 
gowflowConnect With a Mentor Commented:
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
 
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
 
helpfinderIT ConsultantCommented:
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
All Courses

From novice to tech pro — start learning today.