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

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

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

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

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

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

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