When I visited your site, I got a virus, and now I can not get rid of
IGETNET. Please be aware of this and have your site scanned! I have spent
all day trying to get this resolved! :.(

Mc

"JE McGimpsey" wrote in message
...
Take a look he

http://www.mcgimpsey.com/excel/variablerate.html

If you have only the two rates, put total paid in A1, say, then use
something like:

=SUMPRODUCT(--(A1{0,10000}),(A1-{0,10000}),{0.1,0.8})


See the link for more flexible methods.




In article <ynjvd.753530$8_6.116095@attbi_s04,
"Mctabish" <mc@ <nospamjohnsonclan.net wrote:

Thanks Ben,
But this would not quite work as it only looks at that months commission.
I
need to see if 10000 has been paid, and then if so, then it is 90%,
otherwise, I need to deduct 70% as operating cost, and then once 10,000
has
been paid, then change percentage to 90%. So the back half is correct, I
just need to figure out the "test". Also, if say 9000 has been paid, and
this sale would bump the paid commission to being OVER 10,000, then only
deduct UPTO 10,000. Maybe I oversiplified it in original post:.(


Would it be easier to store the amount of commission already paid, and
then
check that? (I need to keep track of it anyways... This is for working up
a
budget as well)
Again, once 10000 has been paid during a given _year_ (accumulative),
then
my commission bumps up to 90%

tia,
Mc

"Ben McBen" wrote in message
...
a formula of the form:


=if(g1<10000,g1*.3,g1*.9)


should do the trick - you can replace the 20000 with a
reference to make it variable...