A formula to accommodate a few simple math conditions

Hello,

I am attempting to find the reimbursement % for a very large data range. The rows are setup so that the first is the charge and the row or rows beneath it (no more then two) are the payments. I am looking for a formula that can accommodate a few different conditions that will occur throughout the data range, which will enable me to drag the formula down. As of now, because I am not able to come up with the appropriate formula, I am inputting the formula in for each set of charge/payment(s) manually. ick! I have an example workbook which thoroughly explains what I need! is there anyone who can help?

It's a bit clunky but it works. Put this in O4 and drag down. Format the cell to a percentage.

Formula:

=IFERROR(IF(F4="","",IF(F6="",-1*SUM(N5:N6)/SUM(M4:N4),-1*N5/SUM(M4:N4))),"")

Let me know if this works for you. Thanks

TPDave,
Thank you very much! Your formula works wonderfully, clunky or not!

Ron Coderre,

Your formula also works wonderfully! I will have to try both to see which will be more efficient with a very large set of data. Thank you very much for your time spent on my concern!

Ron Coderre,

Hello, is there a way to modify the formula to accommodate for a very rare third payment row? I just happen to stumble across one.

Here is an example of what I am talking about

Can anyone help here?

That works brilliantly! Thank you for your time with my problem, and I hope I wasn't to much trouble.