# Remaining to Reach Goal

Alright so I am trying to setup a proformance chart and seem to be getting most of the things that I want done. However I cant get a specific result i want.


Cell1: Target = 2
Cell2: Completed = 1

Cell3: Remaining to Target = 1 (However I can't get the formula to automatically show the remaining amount to be completed until the set target is met)

Second problem is with % values

Cell1: Goal = 60%
Cell2: Sold = 2
Cell3: Attached = 1
Cell4: Ratio = 50% (as calculated by Cell3/Cell2)

Cell5: Attach to Goal: How many more units need to be attached to sold units to meet, or exceed goal % value.