Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
Hi,
I'm trying to add a formula to my accounting worksheet that will calculate my PayPal fees. The fees are as follows: 0 if the sale is $0 2.9%+.30 if the sale is $.01-$3000.00 2.5%+.30 if the sale is $3000.01-$10,000.00 2.2%+.30 if the sale is $10,000.01-$100,000.00 1.9%+.30 if the sale is 100,000.00 I've tried several different IF formulas and am getting error messages. I also tried a SUM formula which was VERY wrong! I'd appreciate any help. Thanks, Leslie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
I'll assume your Sale amount is in cell A1. Use this formula:
=IF(A1=0,0,IF(A1<=3000,A1*.029+.3,IF(A1<=10000,A1* .025+.3,IF(A1<=100000,A1*.022+.3,A1*.019+.3)))) HTH, Elkar "LeslieO" wrote: Hi, I'm trying to add a formula to my accounting worksheet that will calculate my PayPal fees. The fees are as follows: 0 if the sale is $0 2.9%+.30 if the sale is $.01-$3000.00 2.5%+.30 if the sale is $3000.01-$10,000.00 2.2%+.30 if the sale is $10,000.01-$100,000.00 1.9%+.30 if the sale is 100,000.00 I've tried several different IF formulas and am getting error messages. I also tried a SUM formula which was VERY wrong! I'd appreciate any help. Thanks, Leslie |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
=LOOKUP(A1,{0,0.01,3000.01,10000.01,100000.01},{0, 0.029,0.025,0.022,0.019})*A1+0.3
"LeslieO" wrote: Hi, I'm trying to add a formula to my accounting worksheet that will calculate my PayPal fees. The fees are as follows: 0 if the sale is $0 2.9%+.30 if the sale is $.01-$3000.00 2.5%+.30 if the sale is $3000.01-$10,000.00 2.2%+.30 if the sale is $10,000.01-$100,000.00 1.9%+.30 if the sale is 100,000.00 I've tried several different IF formulas and am getting error messages. I also tried a SUM formula which was VERY wrong! I'd appreciate any help. Thanks, Leslie |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
Mama,
Slight omission on the end: =LOOKUP(A1, {0,0.01,3000.01,10000.01,100000.01}, {0,0.029,0.025,0.022,0.019})*A1+ 0.3*(A10) -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Teethless mama" wrote: =LOOKUP(A1,{0,0.01,3000.01,10000.01,100000.01},{0, 0.029,0.025,0.022,0.019})*A1+0.3 "LeslieO" wrote: Hi, I'm trying to add a formula to my accounting worksheet that will calculate my PayPal fees. The fees are as follows: 0 if the sale is $0 2.9%+.30 if the sale is $.01-$3000.00 2.5%+.30 if the sale is $3000.01-$10,000.00 2.2%+.30 if the sale is $10,000.01-$100,000.00 1.9%+.30 if the sale is 100,000.00 I've tried several different IF formulas and am getting error messages. I also tried a SUM formula which was VERY wrong! I'd appreciate any help. Thanks, Leslie |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
Thanks Mama! This is kind of what I did before. If the sale is 0, the
equation below is returning a fee of 30 cents. Should I add an IF clause at the beginning? Leslie Teethless mama wrote: =LOOKUP(A1,{0,0.01,3000.01,10000.01,100000.01},{0 ,0.029,0.025,0.022,0.019})*A1+0.3 Hi, [quoted text clipped - 12 lines] Thanks, Leslie -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200701/1 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
For some reason, the formula isn't working (yes I changed the A1 to the
correct cell). The formula is bringing back 30 cents for sales that were 0. Leslie LeslieO wrote: Thanks Mama! This is kind of what I did before. If the sale is 0, the equation below is returning a fee of 30 cents. Should I add an IF clause at the beginning? Leslie =LOOKUP(A1,{0,0.01,3000.01,10000.01,100000.01},{ 0,0.029,0.025,0.022,0.019})*A1+0.3 [quoted text clipped - 3 lines] Thanks, Leslie -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200701/1 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
OK, I am a hack at excel but I may have solved my formula conundrum. Don't
laugh, it aint pretty. I know the saying, if it aint broke, don't fix it, but is there a simpler formula for doing this calculation? I feel like I just reinvinted the abacus. =IF(I7=100000,I7*0.019+0.3,IF(I7=10000,I7*0.022+ 0.3,IF(I7=3000,I7*0.025+0. 3,IF(I7=0.01,I7*0.029+0.3,IF(I7=0,0))))) This formula seems to work for the following parameters: 0 if the sale is $0 2.9%+.30 if the sale is $.01-$3000.00 2.5%+.30 if the sale is $3000.01-$10,000.00 2.2%+.30 if the sale is $10,000.01-$100,000.00 1.9%+.30 if the sale is 100,000.00 LeslieO wrote: For some reason, the formula isn't working (yes I changed the A1 to the correct cell). The formula is bringing back 30 cents for sales that were 0. Leslie Thanks Mama! This is kind of what I did before. If the sale is 0, the equation below is returning a fee of 30 cents. Should I add an IF clause at [quoted text clipped - 7 lines] Thanks, Leslie -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200701/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |