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,

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"nono404" wrote in message
...
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,

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

"Ken Wright" wrote:

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"nono404" wrote in message
...
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,

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

"Ken Wright" wrote:

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"nono404" wrote in message
...
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,

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"nono404" wrote in message
...
thanks Ken I actually find it by changing Max to Min.
Thanks for your help,

"Ken Wright" wrote:

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)

--------------------------------------------------------------------------
--

"nono404" wrote in message
...
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,