Help with IF calculation

[Joseph31]

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

[dbruggmann]

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

[Joseph31]

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

thanks

Joseph

[Joseph31]

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

[dbruggmann]

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

[Joseph31]

No it does ... make sense

Let me try thank you

Joseph

[dbruggmann]

I'm glad I got it right

[Joseph31]

thanks...It works well..

thank you

Joseph