# Posts by kbowers78

Andy:

Thank you very much. It is sovled

In a while I have a more ambitious option to add to this dictionary but I think I will wait.:spin:

Andy:

I figured it out thank you very much. Now that I have it made how do I run it when I open excel the next time?

Thank you for the code. I apologize but I cannot figure out how it get it to work.
Do I first put the textbox and lable on the sheet and then edit code? Or do I open the Script editor? I am lost.

I am sorry for the ineptness. Any help you can give me is appreciated.

KB

I have an excel file I made that is like a dictionary. I have about 10,000 lines showing an english word and the adjecent column as the word's meaning in Japanese.

I would like to make a type of index search function. Just like in excel help index when you start to type a word as you add more letters it jumps the word on the sheet.

for example:
In my search box I type:
c - then iit jumps to the first c word in the list
ca - then i go to the first ca word
car - then I go to car.

This is what I am after. I assume that it would be a vba application.

I think that the control box should be in a frozen frame so it stays still but the unfrozen pane can jump to the correct word.

Thank you in advance for the help.

KB

I fixed Brantock's formula:

=IF(A1<250,A1*0.1,IF(AND(A1&gt;250,A1<=500),(25+(A1-250)*0.07),IF(AND(A1&gt;500,A1<=1000),(25+17.5+(A1-500)*0.05),IF(AND(A1&gt;1000,A1<=2000 ),(25+17.5+25+((A1-1000)*0.03)),(25+17.5+25+30+((A1-2000)*0.02))))))*1000

Thanks for the help

Thank you for all of your responses.

I tried the first one. I copied the formula into excel and the result was not 73.5K it was 116 or something so something is missing there. I feel that the sample work book link that was provided by Derk may work for me I will try it our and let everyone know

I am tring to write a formual to calucate commission for sales of an item. I started with an IF statement and found that i have more than 7 statements which makes the IF statement unusable.

Here is the deal.
1) for up to 250K the commission is 10%
2) on the next portion up to 500K is 7%
3) on the next part upto 1000K is 5%
4) on the next part upto 2000K is 3%
5) on the rest over 2000K is 2%

Example:

If the sales price = 1200K
1) = 25K (250K*10%)
2)= 17.5K (500-250K = 250K * 7%)
3) = 25 K (1000K -500K = 500K * 5%)
4) = 6K (1200k - 1000K = 200 K *3%)
= 73.5K

Just in case K=1,000