Looking for a way to calculate items needed to reach target %

Thanks Haseeb,

I couldn't really seem to apply the formula you used to this situation. It seems like your formula was using 109 as the number of sales to be 19% of something. I also assumed the 109 was a mistype and you were using 105 which was from my example. However the example would have really been 20 sales out of 105 calls is 19%, not the 20% goal as a previous poster was attempting to assist with.

That being said, I do have a spreadsheet that has the goals listed, right now I can calculate them by hand, just by knowing what numbers are roughly what %. However, as this becomes applied to more agents the time involves becomes too burdensome, hence the need of a formula. I know I am just overlooking something simple, but I just can't seem to find it.

Notice the Sales to Goal in bold, that being the field I am looking for a formula for.