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,
|