Hello everyone..

Can someone help me do this calc. I am not so good at these kind of things...

The example:

Gross Proceed to Provider / Purchase Price = Percentage

If that percentage is < 12 Percent then the number calc is Net proceeds to Provider

If the Percentage is > 12 percent then divide by 2 and then multiply by Purchase price = Bonus to funder

Help.. Please

And what is, if it that percentage is = 12 Percent?

oh good one...that is Net proceeds to provider

thanks

Joseph

Correction on orginal Calc.

If the Percentage is > 12 percent then take the difference between 12 percent and first percentage and divide by 2 and then multiply by Purchase price = Bonus to funder

Sorry

thanks

I certainly don't understand your parameters, but only because my English isn't good enough. Nonetheless, with my understanding I come up with something like this:

Case(

Gross Proceed to Provider / Purchase Price <= 12; "Net proceeds to provider";

Gross Proceed to Provider / Purchase Price > 12; ((Gross Proceed to Provider / Purchase Price) - 12 / 2) * PurchasePrice

)

If it doesn't make sense

No it does ... make sense

Let me try thank you

Joseph

I'm glad I got it right

thanks...It works well..

thank you

Joseph