if the value of a cell is between 2 values

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

Stefi

=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:
 
H

Harish B

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 - formula to display text over a range of values 1
Failing with formula 8
Excel Need Countifs Formula Help 0
SUMIF - how between two numbers 1
Average problem 1
returning a sum value 2
Excel formula, sum the value cell and if empty cell left blank 0
@Sum Conditional Values within a Macro 1

Top