Formula Help

[LeslieO]

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

 

[Teethless mama]

=LOOKUP(A1,{0,0.01,3000.01,10000.01,100000.01},{0,0.029,0.025,0.022,0.019})*A1+0.3

 

[LeslieO via OfficeKB.com]

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

Hi,

[quoted text clipped - 12 lines]

Thanks,
Leslie

 

[LeslieO via OfficeKB.com]

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
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]

 

[LeslieO via OfficeKB.com]

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

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]