Basic Excel Formula Question

M

MichaelG

Good day. I am having problems in getting a formula to work and though
maybe you may see the problem.
I have 3 seperate ranges to look at before giving 1 of 3 answers.
Simply
if "cell " is between "number" and "number" then "2" else if "cell" i
between "number" and "number" then "3" else if "cell" is betwee
"number" and "number" then "4" end if

I just didnt see how to use a range or between these numbers.
The "cell" is the number I will put in. and "number will be a fixe
number never changing.

Thank you
 
J

JulieD

Hi Michael

if i understand you correctly ...

=IF(AND(A1>=1,A1<=5),2,IF(AND(A1>5,A1<=10),3,IF(AND(A1>10,A1<=15),4,"out of
range")))

Cheers
JulieD
 
F

Frank Kabel

Hi
try
=IF(AND(A1>number1,A1<number2),2,IF(AND(A1>number3,A1<number4),3,IF(AND
(A1>number5,A1<number6),4,"not defined")))
 
B

Bob Phillips

Overslept?

Bob

Frank Kabel said:
Hi
try
=IF(AND(A1>number1,A1<number2),2,IF(AND(A1>number3,A1<number4),3,IF(AND
(A1>number5,A1<number6),4,"not defined")))
Click to expand...
 
Top