Negative percent that should be postive

**Jackie010** · 01-18-2013, 09:28 AM

=ROUND(IF(I17=0,IF(G17=0,0,SIGN(-G17)),IF(G17=0,SIGN(I17),(G17-I17)/ABS(G17))),5)

so, I17 = 0.00 and G17 = 112.00 (both positive)
why is this giving me a (negative!!) -100.00%

**martindwilson** · 01-18-2013, 09:33 AM

its only getting as far as this
=IF(I17=0,IF(G17=0,0,SIGN(-G17))
i17=0 and g17 <>0 so return SIGN(-G17)

**Jackie010** · 01-18-2013, 09:57 AM

do you know why?

**zbor** · 01-18-2013, 10:57 AM

What you expect? It should return -100%:

IF(I17=0,IF(G17=0,0,SIGN(-G17))

I17 = 0 so

IF(G17=0,0,SIGN(-G17)

G17 is 100 so it will return sign(-100) and that's -1

-1 is -100%