Formula if a number is between 2 amount than answer will be x

P

Princess

I need help please!!! For example if I am in cell C3. I want to put a formula
in that if in B3 the number I have entered is between 4 and 6 for example
than i want the answer in C3 to be 2.
 
J

joeu2004

Princess said:
I want to put a formula in that if in B3 the number I
have entered is between 4 and 6 for example
than i want the answer in C3 to be 2.
Click to expand...

You also need to specify what value you want if B3 is not
between those limits. I will use 1 ....

=IF(AND(4<=B3,B3<=6), 2, 1)
 
Top