I have an excel spreadsheet that does a bunch of calculations and I need help understanding how to perform a specific formula.
target e5 = $467,000,000.00
sold e8 = $154,134,335.36
gap e8 - e5 = -$312,865,664.64
pipeline = $202,265,246.67
coverage is what percentage of the gap is covered by the pipeline, what formula will get me that accurate %
Keep in mind that sometimes the gap could be a positive number if that group has made their numbers.