if the value of a cell is between 2 values
 

I want to set value of a cell (h2) to 30 if the value of other cell (d2) is
between 2000 & 5000.
and to 60 if between 5000 & 10000 by using formula.

how can i do this.
--
Harish B.

if the value of a cell is between 2 values
 

=IF(A2<2000,"",IF(A2<5000,30,IF(A2<10000,60,"")))

--
__________________________________
HTH

Bob

"Harish B" wrote in message
...
I want to set value of a cell (h2) to 30 if the value of other cell (d2) is
between 2000 & 5000.
and to 60 if between 5000 & 10000 by using formula.

how can i do this.
--
Harish B.

if the value of a cell is between 2 values
 

=IF(AND(D2=2000,D2<=5000),30,IF(AND(D25000,D2<=1 0000),60,"what if d2<2000
or d210000"))

Regards,
Stefi

€žHarish B€� ezt Ã*rta:

I want to set value of a cell (h2) to 30 if the value of other cell (d2) is
between 2000 & 5000.
and to 60 if between 5000 & 10000 by using formula.

how can i do this.
--
Harish B.

if the value of a cell is between 2 values
 

Try this !


=IF((d2=2000)*(d2<=5000),30,IF((d2=5000)*(d2<=10 000),60,""))

On Sep 11, 6:14*am, Harish B
wrote:
I want to set value of a cell (h2) to 30 if the value of other cell (d2) is
between 2000 & 5000.
and to 60 if between 5000 & 10000 by using formula.

how can i do this.
--
Harish B.

if the value of a cell is between 2 values
 

thank you, stefi

--
Harish B.


"Stefi" wrote:

=IF(AND(D2=2000,D2<=5000),30,IF(AND(D25000,D2<=1 0000),60,"what if d2<2000
or d210000"))

Regards,
Stefi

€žHarish B€� ezt Ã*rta:

I want to set value of a cell (h2) to 30 if the value of other cell (d2) is
between 2000 & 5000.
and to 60 if between 5000 & 10000 by using formula.

how can i do this.
--
Harish B.