# 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 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 on other sites

Thanks still cant get it to work, I will work around it for now

##### 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 on other sites

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

##### Share on other sites

I think I have figured it out now Thanks

##### Share on other sites

I think I have figured it out now Thanks

What was the solution?

##### Share on other sites

What was the solution?

I went old school and used a calculator

##### Share on other sites

I went old school and used a calculator

ROFL!

I was expecting some complex code.

##### Share on other sites

...

And I took the time to write the code for you...see post 4

B:)

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