I am calculating our Net Days in AR for the month. The goal (which is the number to NOT EXCEED) is 55 days meaning anything 55 and below, goal has been achieved. Anything 56 and above, goal has not been achieved.

The Actual net days in AR for the month is 78.4 which means goal has NOT been achieved by -23.4 days. I need the percentage of goal achieved for this but Im not sure how to do this when the goal is less than a number. Please help.

10 Net Days in AR 11 Goal: s55 Days 12 Var 13 % of Goal Met 14 Goal Met 78.4 55.0 23.4