Are there any excel guru's in here??

Soldato
Joined
2 Jan 2004
Posts
7,293
Location
Chesterfield
I'm trying to input a (fairly simple) formula into an existing excel spreadsheet but I'm not sure how to do it as I only know the basic functions!!

Basically I want the sheet to select one of 3 different values (an admin charge of £5, £10 or £25) depending upon whether a total lands between £0 and £1000, £1001 and £5000 or £5000+

Can anyone tell me how this can be done?? (I can post pics of the spreadsheet if that helps??)

Thanks...
 
Soldato
Joined
12 Jan 2006
Posts
2,547
If you just want to view certain values try creating a filter

- Click the column you want to filter
- Data > Filter
- This will create a little drop down box, simply select the values you want
 
Soldato
Joined
12 Jan 2006
Posts
3,617
Location
Edinburgh
Assuming TOTAL is Column A and ADMIN CHARGE is Column B.

In Cell B1: =IF(A1<=1000, 5, IF(A1<=5000, 10, 25))

Drag formula down Column B to repeat it in the rest of the cells.
 
Top Bottom