There is comparison data by 2 columns. e.g:

Yr 2011 Yr2012 %

$10 $12 20% [formula = (12-10)/10]

-$10 $12 220%

if i copy the formula from 1st line then the answer for the line 2 will be -220% instead of 220%.

Skip to content
### Leave a Reply

There is comparison data by 2 columns. e.g:

Yr 2011 Yr2012 %

$10 $12 20% [formula = (12-10)/10]

-$10 $12 220%

if i copy the formula from 1st line then the answer for the line 2 will be -220% instead of 220%.

You must be logged in to post a comment.

## 3 replies to "Negative data for comparison"

The -220% is caused by the negative denminator. To get positive 220%, you can use the formula abs which means absolute, i.e. positive number. [Formula=(12-(-10))/abs(-10)]

Thanks

Thanks