Dr_Frankenstein Posted March 28, 2009 Posted March 28, 2009 I am creating my own ebay profit/loss calculator I am almost done but I am a little stuck on one formula I am trying to calculate my ebay fee's based on the Sale Price of an item I am pretty sure I need to use an IF statement but let me know Item from Share this post Link to post Share on other sites More sharing options...
Crazy_Nate Posted March 28, 2009 Posted March 28, 2009 (edited) I don't think you can do if...elseif type statements in excel, but, you can do nested if statements. Example: =IF(A1=1,1,IF(B1,2,IF(C1,3,4))) This would start in A1, see if the value is 1, and report 1 if it is, if not, it checks the next parameter (in this case B1 = true), and continues on. You can do this with if ([cell value] < first number, first operation, if ([cell value] < second number, second operation, if ([cell value] < third number, third operation, [whatever for > third number]))) Edited April 1, 2009 by Crazy_Nate Share this post Link to post Share on other sites More sharing options...
Dr_Frankenstein Posted March 28, 2009 Posted March 28, 2009 Thanks still cant get it to work, I will work around it for now Share this post Link to post Share on other sites More sharing options...
Crazy_Nate Posted March 28, 2009 Posted March 28, 2009 Try this =IF(A1<1,0.099*A1+0.1,IF(A1<5,0.099*A1+0.15,0.099*A1+0.25)) Just replace A1 with whatever cell value your item is in. Share this post Link to post Share on other sites More sharing options...
Silverfox Posted March 28, 2009 Posted March 28, 2009 If you search for 'nested If' in Excel help, it will explain better than us nerds Share this post Link to post Share on other sites More sharing options...
Dr_Frankenstein Posted March 28, 2009 Posted March 28, 2009 I think I have figured it out now Thanks Share this post Link to post Share on other sites More sharing options...
mikeock Posted March 31, 2009 Posted March 31, 2009 I think I have figured it out now Thanks What was the solution? Share this post Link to post Share on other sites More sharing options...
Dr_Frankenstein Posted March 31, 2009 Posted March 31, 2009 What was the solution? I went old school and used a calculator Share this post Link to post Share on other sites More sharing options...
mikeock Posted April 1, 2009 Posted April 1, 2009 I went old school and used a calculator ROFL! That's a great answer. I was expecting some complex code. Share this post Link to post Share on other sites More sharing options...
Crazy_Nate Posted April 1, 2009 Posted April 1, 2009 ... And I took the time to write the code for you...see post 4 B:) Share this post Link to post Share on other sites More sharing options...
hardnrg Posted April 1, 2009 Posted April 1, 2009 CrazyNate's formula is sound. That's how I would do it. No need for a calculator when you have Excel Share this post Link to post Share on other sites More sharing options...
Dr_Frankenstein Posted April 1, 2009 Posted April 1, 2009 I will try it again a bit later on, Maybe I should put my glasses on lol Share this post Link to post Share on other sites More sharing options...
Recommended Posts