if statement Simplification

On the Ebay fees page, CODE refers to category (D) on Inventory page. If CODE "ELCTR" for example, it will take LISTING PRICE (X) and add a fee of 8% (H), 12.5% if more than $50 (I), 13.5% if more than $1000 (J), and add $.35 (G).
The Paypal fees (P) refers to the sum of LISTING PRICE and LISTING S&H (X,Y). and charges are 2.9% unless greater than $3000 then its 2.5%plus the constant fee of $.30 per transaction.

Ive added a newer version of this that Ive been working on wherein there are a couple of new rows and product info to work with. My main problem is getting these formulas to work and then being able to apply to each row quickly as I will have several thousand rows to create when Im finished and it would take a very long time to have to keep typing each one out or copy paste and going in and fixing cells. Let me know if you need more info.

Also something i wanted to eventually add was a way to take any active (AB) and generate a printable list. to be active (Q) must be less than (S)

Heres a copy of my old sheet that iused. it doesnt have category option but it shows kinda how i want it to work

The Ebay fees: (This is not a working formula, its simply showing what I want the formula to say.)
('Inventory!'X * 'eBay Fees'!H) + if > 50, add ('Inventory!'X * 'eBay Fees'!I) + if > 1000, add ('Inventory!'X * 'eBay Fees'!J) + 'eBay Fees'!G
The row numbers are dependant on category shown ('Inventory'!D)
This column is to show the Ebay fee which is then added to columns J through P.

The Paypal Fee:
('Inventory'!X + 'Inventory'!Y) * 'eBay Fees'!H (2.9%) (2.5% if sum of 'Inventory'!X:Y > $3000)

I dont know how to make it any simpler than that. Look at the formulas that are in the spreadsheet already to show where everything is suppose to point.Im including the two worksheets again. inv97-03.xls is the current one. ebay1.xls is my old one that works but you cant choose category (Column D) or or price variable

Alright, everything works in the spreadsheet except for two columns. Ebay Fees (M) and Paypal Fees (P). Please use the spreadsheet Ive included in this reply as it reflects all the new changes Ive made and may be a little easier to understand. The first thing to understand is that the white boxes are user input. Everything in the gray should be formulas that are figured automatically once data is input in the white cells. The Ebay fees category should work like so with the formulas being put into cell M6, M7, M8, and so on and so on. I would like a formula I can copy and paste without having to fix every row. The formula should take the category chosen (Column D) and figure out the fees associated with that category based on price. The price comes from column X LISTING PRICE. So if $100 is input in X6 choosing category OTHER in D6, it would give output of 18.35 (.35 ('eBay Fees'!G10) plus 18% ('eBay Fees'!H10 plus 'eBay Fees'!I10)(18% because the Listing Price is greater than 50). Every category shown should reflect charges on sheet 'eBay Fees'. The Paypal Fees Category should work like so with the formulas being put into cell P6, P7, P8, and so and so on. I would like a formula I can copy and paste without having to fix every row. The starting price for this one comes from column AA ( the sum of listing price(x) and listing shipping(y)). So if 90 is put into x6 and 10 is put into Y6, AA should have output of 100. Then output of P6 should read 3.20 (.3 ('eBay Fees'!G11) plus 2.9% of AA ('eBay Fees'!H11). It would be 2.5% if over 3000. I believe that explains everything as much as possible. The formulas I have in Cells M22, M23, M24, etc and P22, P23, P24, Etc are temp formulas that work because most of my products are in category other and are less than 50 so there is a very simplified formula there. The output should be the same though with a new more complex formula.

That kind of works except now Im looking for a way to make it so that I can just copy that cell and paste it on the one underneath and still have it be valid without having to go into the formula and change it manually. You know how it changes the cells when you copy and paste to make it work with the cell you place it in. This formula doesnt work like that.