xeven_
Active Member
- Joined
- Jan 20, 2012
- Messages
- 302
[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl72, width: 64"]2012[/TD]
[TD="class: xl73, width: 64"]$13,641 [/TD]
[TD="class: xl74, width: 64"]4%[/TD]
[/TR]
[TR]
[TD="class: xl72"]2013[/TD]
[TD="class: xl73"]$13,057 [/TD]
[TD="class: xl74"]-4%[/TD]
[/TR]
[TR]
[TD="class: xl72"]2014[/TD]
[TD="class: xl73"]$15,233 [/TD]
[TD="class: xl74"]17%[/TD]
[/TR]
[TR]
[TD="class: xl72"]2015[/TD]
[TD="class: xl73"]($6,145)[/TD]
[TD="class: xl74"]-140%[/TD]
[/TR]
[TR]
[TD="class: xl72"]2016[/TD]
[TD="class: xl73"]$6,845 [/TD]
[TD="class: xl74"]-211%[/TD]
[/TR]
[TR]
[TD="class: xl72"]2017[/TD]
[TD="class: xl73"]($8,920)[/TD]
[TD="class: xl74"]-230%[/TD]
[/TR]
[TR]
[TD="class: xl72"]2018[/TD]
[TD="class: xl73"]($22,802)[/TD]
[TD="class: xl74"]156%[/TD]
[/TR]
</tbody>[/TABLE]
I am using office 365 pro plus (excel) When I paste my data and then add the =(B2-B1)/B1 in cell C2 the formula is calculating some cells corrrectly and others it isnt. It seems to go from positive to negative correctly but wont go from negative to positive. Does anyone have a fix for this?
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl72, width: 64"]2012[/TD]
[TD="class: xl73, width: 64"]$13,641 [/TD]
[TD="class: xl74, width: 64"]4%[/TD]
[/TR]
[TR]
[TD="class: xl72"]2013[/TD]
[TD="class: xl73"]$13,057 [/TD]
[TD="class: xl74"]-4%[/TD]
[/TR]
[TR]
[TD="class: xl72"]2014[/TD]
[TD="class: xl73"]$15,233 [/TD]
[TD="class: xl74"]17%[/TD]
[/TR]
[TR]
[TD="class: xl72"]2015[/TD]
[TD="class: xl73"]($6,145)[/TD]
[TD="class: xl74"]-140%[/TD]
[/TR]
[TR]
[TD="class: xl72"]2016[/TD]
[TD="class: xl73"]$6,845 [/TD]
[TD="class: xl74"]-211%[/TD]
[/TR]
[TR]
[TD="class: xl72"]2017[/TD]
[TD="class: xl73"]($8,920)[/TD]
[TD="class: xl74"]-230%[/TD]
[/TR]
[TR]
[TD="class: xl72"]2018[/TD]
[TD="class: xl73"]($22,802)[/TD]
[TD="class: xl74"]156%[/TD]
[/TR]
</tbody>[/TABLE]
I am using office 365 pro plus (excel) When I paste my data and then add the =(B2-B1)/B1 in cell C2 the formula is calculating some cells corrrectly and others it isnt. It seems to go from positive to negative correctly but wont go from negative to positive. Does anyone have a fix for this?