if statement Simplification

**sk81681** · 06-05-2009, 12:27 AM

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.

**sk81681** · 06-05-2009, 02:58 AM

its not that hard. Ive got the formula already in M6. It just doesnt work. Everything points where it needs to though. I just dont have experience or knowledge as to why it doesnt work. All im asking is look at the formula and tell me whats wrong. You dont need to understand where its getting what data from where and what its doing. just look at the physical formula and tell me where the error is.I have some formulas starting in M22 that show you exactly what answer you should get. This isnt that hard. ITs a very basic formula. I think you may need to find something youre better at.

**sk81681** · 06-05-2009, 03:55 AM

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.