nested if function problem

[headache]

Trying to model the following but im not plugging in the right nested if statement. Please help. Would even be better if I can develop this model dynamically.

Here is my problem> modeling financial debt recoupment by investors and borrowers (revenue versus cost)

x>0<=5,000,000 (x=revenue)

y=2,000,000 ( y=cost)

A=x B=x C=x D=investor E=borrower

If A>y up to 110% of y but not less than 90% of y, then A returns 90% of A to D and 10% of A to E

If B>y up to 150% BUT not less than 110% of y, then B returns 50% of B to D and 50% of B to E

If C>y up to 200% but not less than 150% of y, then C returns 30% of C to D and 70% of C to E

Thanks!

[headache]

Im also trying to build it such that the rates can be changed without having to work directly in the cells.

Help would be appreciated.

[Carim]

Hi,

To simplify everybody's headache, why don't you upload a zipped copy of your model ...?

[headache]

will do Carim

[Maistrye]

The attached file has it done two ways.

Option 1:
Assumes you actually wanted all 3 columns separately listed. (You'll probably want to adjust the <= to < in some instances so there is no overlap in the ranges).... That said, I don't recommend this way. (Actually, I think this particular one is probably just a bad interpretation of what you wanted - but I left it in anyway.)

Option 2:
You probably want it this way, with the ranges independent of each other.

Scott

[headache]

Thanks,

I couldn't attach the zip file Carim but I'll get to it from here. Thanks Maistrye! How can I change the rates without working in the cells...if you have any idea how i could make this dynamic I would be grateful.