=IF(F7=0,"",MAX((F7-ABS(K7/3*12))/F7,0))

I would like to know if it is flat WRONG mathmatically, or the formula is wrong for the intended purpose.

I know his intent was to calculate the percentage of the number left at the end of the 1st Quarter of the year from the beginning of the year.

looks like this:

**Excel 2010**

B | C | D | E | F | G | H | I | J | K | L | M | |
---|---|---|---|---|---|---|---|---|---|---|---|---|

4 | Number | Number to | Num possible | Numbers to subtract by Month: | ANNUALIZED | |||||||

5 | Beg of Qtr | Disregard | End of QTR | Month # 1 | Month # 2 | Month # 3 | TOTAL | Number Kept: | ||||

6 | ||||||||||||

7 | 64 | 1 | 63 | 2 | 5 | 0 | 7 | 55.56% |

<tbody>

</tbody>

**1st Qtr 2014**

Worksheet Formulas
<tbody> </tbody> |

<tbody>

</tbody>

I Believe it should be this:

**Excel 2010**

D | E | F | G | H | I | |
---|---|---|---|---|---|---|

10 | Num possible End of QTR | Num to subtract Total | Number Kept | % Kept | ||

11 | 63 | 7 | 56 | 88.89% |

<tbody>

</tbody>

**1st Qtr 2014**

Worksheet Formulas
<tbody> </tbody> |

<tbody>

</tbody>

any input would be greatly appreciated!