SkzDaLimit
Board Regular
- Joined
- Dec 1, 2002
- Messages
- 54
Hey guys and gals! You all have been so awesome helping me in the past with problems. I so much appreciate it.
Need you all again for another project. I am working on 2 spreadsheets and am having a dilemma trying to come up with formulas.
Spreadsheet 1
F23 contains the final sales price of an item. L23 will calculate the fee using the following criteria: Sale price up to $14.42 the fee is $0.50, sale price $14.43 to $499.99 the fee is 3.5%, sale price $500.00 and above the fee is $17.50 + 1.5% of the amount over $500.00
Spreadsheet 2
F23 contains the final sales price of an item. L23 will calculate the fee using the following criteria: Less than $10.00, fee is $0.50. Less than $50.00, fee is $1.00. Less than $100.00, fee is $3.00, Less than $1000.00, fee is $5.00. $1000.00 and greater, fee is $10.00.
Thanks again for your help everyone. Someday I'll get the hang of this formula stuff!
Need you all again for another project. I am working on 2 spreadsheets and am having a dilemma trying to come up with formulas.
Spreadsheet 1
F23 contains the final sales price of an item. L23 will calculate the fee using the following criteria: Sale price up to $14.42 the fee is $0.50, sale price $14.43 to $499.99 the fee is 3.5%, sale price $500.00 and above the fee is $17.50 + 1.5% of the amount over $500.00
Spreadsheet 2
F23 contains the final sales price of an item. L23 will calculate the fee using the following criteria: Less than $10.00, fee is $0.50. Less than $50.00, fee is $1.00. Less than $100.00, fee is $3.00, Less than $1000.00, fee is $5.00. $1000.00 and greater, fee is $10.00.
Thanks again for your help everyone. Someday I'll get the hang of this formula stuff!