if the value of a cell is between 2 values

  • Thread starter Thread starter Harish B
  • Start date Start date
H

Harish B

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.
 
=IF(AND(D2>=2000,D2<=5000),30,IF(AND(D2>5000,D2<=10000),60,"what if d2<2000
or d2>10000"))

Regards,
Stefi

„Harish B†ezt írta:
 
thank you, stefi

--
Harish B.


Stefi said:
=IF(AND(D2>=2000,D2<=5000),30,IF(AND(D2>5000,D2<=10000),60,"what if d2<2000
or d2>10000"))

Regards,
Stefi

„Harish B†ezt írta:
Click to expand...
 
Back
Top