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