nesting if statements

[Guest]

OK let me try to explain this one...

Cell A1 has a number between 0 and 75.

Cell A2 needs to have some nested If statements that reflect the following:
If A1 is between 2 and 4 then A2 should read 80
If A1 is between 5 and 14 then A2 should read 120
If A1 is between 15 and 24 then A2 should read 160
If A1 is 25 and higher then A2 should read 200

 

[Domenic]

Try...

=LOOKUP(A1,{2,5,15,25},{80,120,160,200})

Hope this helps!

 

[Biff]

Hi!

A couple of questions:

What if A1 is <=2 ?

between 2 and 4
between 5 and 14
between 15 and 24

Do you really mean:

=2 and <=4
=5 and <=14
=15 and <=24

Biff

 

[Guest]

=IF(AND(A1>2,A1<4),80,IF(AND(A1>5,A1<14),120,IF(AND(A1>15,A1<24),160,IF(A1>25,200))))

Yoou used "between" and so that is how I set up the formulas...
In other words, the following inputs in A2 give the following results:
1 = FALSE
2 = FALSE
3 = 80

You may want to set up a table that allows you to link the formulas so that
you can easliy change the values...

Jim

 

[dominicb]

Good evening tjb

You haven't indicated wha is to happen if the number in cell A1 is 0 o
1 - in the example below, 0 is returned. Other than that I think i
covers your requirements.

=IF(A1>=25,200,IF(A1>=15,160,IF(A1>=5,120,IF(A1>=2,80,0))))

HTH

Dominic