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.
|