Apply various percentage with sales between a & b, b & c, etc.
John. You are wonderful. The formula you proposed was perfect! Thanks so
much for the help. You saved me tons of labor and worry.
--
Rick R
"Rick R" wrote:
I want the bonus percentage to change from zero to 1% with sales are between
$70,000 and $89,999.99
to 2% when between $90,000 and $119,999.99
to 4% when between $120,000 and $144,999.99
to 5% when between $145,000 and $174,999.99
to 7% when between $175,000 and $204,999.99
and 9% when between $205,000 and $5,000,000
The total sales cell is E4 and the Bonus Percentage cell is O5
Thanks for the help.
--
Rick R
|