VLOOKUP question

heather143

New Member
I'm trying to use a vlookup to figure out how to add commision per shares on my workbook

here is my commission info:

under 25 shares: 12.00\$
from 25 to 49 shares: 1.5% of purchase price
from 50 to 74 shares: 1.25% of purchase price
from 75 to 99 shares: 1% of purchase price
over 100 shares: 50\$

all of my purchase price info is listed on another worksheet along with the number of shares bought....I'm sure this should be easy but i am having trouble setting up the table for the shares and price, and setting up the VLOOKUP formula-im guessing vlookup would be my best bett...
ty

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Replies
1
Views
252
Replies
2
Views
341
Replies
22
Views
944
Replies
1
Views
208
Replies
12
Views
639

1,190,590
Messages
5,981,813
Members
439,735
Latest member
Cbegg

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back