# 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%?
###### Who is Participating?

x

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

Commented:
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

IT 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

Author 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

Commented:
you put in D17 this formula
=(D16-D15)/D15

make sure it is formatted with  %
gowflow
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.