I am trying to use the if statement to the following pruposes:

if A1 is greater than 13000 but less than 14000 then £25 is entered
into the cell. however:
if A1 is greater than 14000 but less than 15000 then £35 is entered
into the cell. however:
if A1 is greater than 15000 but less than 16000 then £50 is entered
into the cell. and so on

Has anyone anu ideas how to acheive this??

Thanks

John

Hi John,

If I understand correctly, and provided your limits are stored in
column E, following formula could help :
=25+(MATCH(A1,E1:E12)-1)*10

HTH
Cheers
Carim

You can use the formula

=IF(A113000,IF(A1<14000,25,IF(A1<15000,35,IF(A1<1 6000,50,70))))

(and format the cell as currency)

but depending what you mean by "and so on" this will soon run into
trouble by having too many nested functions.

A better way is to use a lookup table, e.g. (in 2 columns)

13000 25
14000 35
15000 50
16000 70
and so on..

Name this table as (say) LookupTable, then use the formula:
=VLOOKUP(A1, LookupTable, 2)

As well as avoiding the nested functions problem, this is a lot
clearer, and makes it much easier to maintain the table of values.


HTH
Andrew


wrote:
I am trying to use the if statement to the following pruposes:

if A1 is greater than 13000 but less than 14000 then £25 is entered
into the cell. however:
if A1 is greater than 14000 but less than 15000 then £35 is entered
into the cell. however:
if A1 is greater than 15000 but less than 16000 then £50 is entered
into the cell. and so on

Has anyone anu ideas how to acheive this??

Thanks

John