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


I have an excel spreadsheet that does a bunch of calculations and I need help understanding how to perform a specific formula.

sample 1
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.

Excel Formula help: getting a coverage value

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.