A formula to accommodate a few simple math conditions

[nicki_rae22]

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?

[TPDave]

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

Please Login or Register  to view this content.

Let me know if this works for you. Thanks

[Ron Coderre]

Using your posted workbook, this regular formua, copied down, calculates the Reimb Pct

Please Login or Register  to view this content.

Is that something you can work with?

[nicki_rae22]

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

[nicki_rae22]

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!

[nicki_rae22]

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.

[nicki_rae22]

Here is an example of what I am talking about

[nicki_rae22]

Can anyone help here?

[Ron Coderre]

Using your posted workbook, try this regular formula, copied down:

Please Login or Register  to view this content.

Is that something you can work with?

[nicki_rae22]

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