I need help to get formula to calculate royalties recouped with sa

[nono404]

I need help to get a formula to calculate royalties recouped with sales

If I have $10,000 min guaranteed and I have 15% royalties to be recouped.
How do I calculate it automatiquely ?Need to show 10,000 until I reach them
and then will have 15% thereafter,

Thanks,

 

[Ken Wright]

=MAX(10000,xyz*15%) where xyz is your Royalties calc

 

[nono404]

Thanks Ken,
But this give me the reverse of what I am looking for .This give a max of
10,000 when I am looking at a minimun of 10,000.Could you help ?
Thanks,

nora

 

[nono404]

thanks Ken I actually find it by changing Max to Min.
Thanks for your help,

 

[Ken Wright]

That is incorrect for what you stated

If you use MIN then the highest amount you can possibly get is 10,000 but
you said that was your minimum amount guaranteed.

If your royalties calc amounted to only 50, then the formula with MIN will
give you 50 and not 10000.
If your royalties calc amounted to 50000, then the formula with MIN will
give you 10000 and not 50000.

That is the complete opposite of what you asked for, so just be sure it's
doing what you think.