View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana DeLouis[_3_] Dana DeLouis[_3_] is offline
external usenet poster
 
Posts: 690
Default How do I perform calculation within IF statement?

Hi. Another option...

= Min(0.0875*A1, 1.3125 + 0.035*A1, 21.3125 + 0.015*A1)

= = =
HTH :)
Dana DeLouis




Steven Masterson wrote:
Hello,

I'm trying to create a worksheet that will calculate all the fees eBay
charges for an item when I enter the sold price. I've created a basic spread
sheet as follow:
A1:
1850
A2:
=IF(A1<25,=(A1/100)*8.75,IF(A1<1000,=((A1-25)/100)*3.5+2.19,IF(A11000,=((A1-1000)/100)*1.5+2.19+34.12,"Incorrect Sold Price")))

ebay will charge you a final value fee based on how much your item is sold
for, the calculation is as below:
$0.01~$25.00=8.75% of the closing value

$25.01~1,000=8.75% of the initial $25.00 (2.19), plus 3.5% of the remaining
closing value balance

Equal to or Over $1000=8.75% of the initial $25.00 ($2.19), plus 3.5% of the
initial $25.01~$1,000 ($34.12), Plus 1.5% of the remaining closing value
balance

So what I was trying to achieve with the formula above is basically using
the IF statement to verify one of the three condition, where A1 is the final
value for the item, this formula in the A2 field should see which price range
A1 falls into, and apply the correct calculation to display result.
(You will probably think I'm stupid after you realize I was dividing A1
field by 100 and times a certain number just because I don't know how to
properly do percentage within Excel formula...)

I've also tried using LOOKUP function, but doesn't matter how I modify it,
it will either tell me there's an error or will simply spit out the entire
line of formula instead of a calculated result.

Any help is really appreciated, thanks a lot!!