Thread: goals

i'm working on an excel spreadsheet, having trouble trying to find the solution.
2009 goal is <1.25% (cell b4)
As of 2-28-09 it is 1.72% (cell c4)
need to find the percentage above/below goal (cell d4)

i have tried =c4 - b4 to no avail

Originally Posted by elbub64

i'm working on an excel spreadsheet, having trouble trying to find the solution.
2009 goal is <1.25% (cell b4)
As of 2-28-09 it is 1.72% (cell c4)
need to find the percentage above/below goal (cell d4)

i have tried =c4 - b4 to no avail

x = (-1 + c4 / b4)*100 will give you the percentage of b4 above c4.

IE x is such that: b4 + x% = c4. (If your calculator lets you add percent in that way).