Jump to content
Dr_Frankenstein

Excel Formulas

Recommended Posts

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

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 by Crazy_Nate

Share this post


Link to post
Share on other sites

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

If you search for 'nested If' in Excel help, it will explain better than us nerds :lol:

Share this post


Link to post
Share on other sites
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

:lol:...

 

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

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
Guest
This topic is now closed to further replies.

×
×
  • Create New...