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.