MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Function to calculate % change in cell range

Posted by Perry Cochran on January 07, 2002 10:32 AM

I am compiling end of year stats. I need to know which function will calculate the % difference (either + or -).

Thanks in advance,

Perry Cochran

Posted by Loren on January 07, 2002 12:06 PM

there isn't a function. Use =B/A - 1 and format as %. Subtracting the 1 has the
effect of removing 100% from the ratio; saves the extra step of subtracting.