Require assistance with two negative numbers in formula AND % Change

[Charlinda]

Good Day,

I'm working with an income statement and need to reflect the % Change between 2013 and 2014. Please refer to the attached image.

My problem comes in with the negative numbers Maths and more advanced excel is not my strong point...

Do you require more information?

Warmest care,


CharlindaExcel.png

[Sam Capricci]

I believe either one of these will give you the percent change… =1-(B6/C6) or =(C6-B6)/C6

[Charlinda]

I believe either one of these will give you the percent change… =1-(B6/C6) or =(C6-B6)/C6

Hello Sambo Kid,

Thank you so much! How did I get to be so lucky for you to assist me? I've used =1-(C6/B6) which has given the correct percentages, however, some "negative" numbers should be "positive" and vice versa. You will see all the green highlighted cells should be positive and the blue highlighted cells should be negative. Would you please assist with the correction there of?

Warmest care,

Charlinda

[Sam Capricci]

Change it to (c4/b4)-1 and see if that corrects the negatives.

[Charlinda]

Thank you Sambo Kid! Yeay! How does it get any better than this?