Are there any excel guru's in here??

[StevieP]

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

 

[Chronictank]

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

 

[div0]

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.

 

[StevieP]

Thanks guys!

That sorted it nicely for me!