archive

Archive for August, 2013

Formula for counting percentages between negative values

Wednesday, August 14th, 2013

Say, you have “300” and “-300” as two values and want to calculate the percentage change between them. With the formula

  "=(A2 - B2) / ABS(B2)"

it’ll do it.