Another Sales Spreadsheet Question

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! :)
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Hi,

For spreadsheet one try:

=IF(F23="","",IF(F23<14.43,0.5,IF(F23<500,F23*3.5%,17.5+((F23-500)*1.5%))))

HTH
ian
 
Upvote 0
Hi,

Sorry I had to dash after the first one!!

Embedded ifs are pretty simple to do -if you use notepad or wordor something to layout what you want, until you get the hang of them....if you imagine the below in Notepad, it shows the basic steps, ignore the big formula and just break it down into little steps, adding them all together at the last step and sticking an equal sign in front:)

HTH
Ian

Excel Workbook
A
2=if(something=something,true, false)
3
4Ignore the equal sign at the start of the formula
5Ignore the "false" part of the formula for now
6Just make sure that you leave a comma at the end of the below sections
7Taken from your original post
8IF(F23="","",
9IF(F23
10IF(F23
1117.5+((F23-500)*1.5%)
12
13=IF(F23="","",IF(F23
Sheet1
 
Upvote 0

Forum statistics

Threads
1,224,600
Messages
6,179,836
Members
452,947
Latest member
Gerry_F

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top