Hello All!
I am new to excel, and i am working on the fly. I accidentally posted this in another thread already so i apologize.
I need help figuring out a pricing tier for a compensation plan on EXCEL 2016.
Pricing is as follows:
<$1,000,000 x .0027= $2700
$1,000,000-$2,000,000 x .0035= $3500
$2,000,000-$3,000,000 x .0045= $4500
$3,000,000-$4,000,000 x .0055= $5500
>$4,000,000 x .007= $7000
I have a sum of total dollar amounts but am at a loss for how to calculate for the tier dollar amounts per million in a single cell.
EX. ($3,562,000) $2700+$3,500+$4,500+$3,091= $13,791
Thank you!
Bookmarks