Excel formula

tru

I've just made a new spreadsheet, used a few different formulas, but now I'm stuck I need one for e-bay fees, I've got a 'List Price' column and a 'Fees' column, in the 'Fees' column I want -

= between £0.01 - £0.99 £0.15, between £1.00 - £4.99 £0.20, between £5.00 - £14.99 £0.35, between £15.00 - £29.99 £0.75

The bold numbers are the prices I want to show in the column, depending on the price that's in the 'List Price' column.

I've just read that back to myself, does it make sense? :rotfl:

Mattjimf

By the looks of things you need a logical statement. If you open the insert menu select function, select logical from the drop down menu. You will be give nthe options of AND, False, If, not, Or and True. One of these probably AND, IF or OR will be what your looking for.

Chippy_Minton

Assuming your first List Price is in A2, and Fees is in column B, put the following formula in B2:

=IF(A2<1,0.15,IF(A2<5,0.2,IF(A2<15,0.35,IF(A2<30,0.75))))

The formula doesn't include the fee for prices over £29.99. If that's based on a percentage of the list price, let me know and i'll adapt the formula to include it.

tru

:T

Chippy, thanks. All I had to do was change A2 to D10, and paste it in column E. I can add the other fees now I can understand IF (I always wondered what it was for)