If, then for X>2 but less than 4

[ChrisS92]

Hi,

How do I set an if/then statement for a result between two values? I have a value in A1 that will change periodically and I want the cells beneath it to reflect that change (this is part of a greater summation scheme that's already been set up):

A1= 2

A2: if (x<1, A1, 0), this one is easy
A3: if (3<x>1, A1, 0), I want this box to populate if it's greater than or equal to 1 but less than 3
A4: if (5<x>3, A1, 0), I want this box to populate if it's greater than or equal to 3 but less than 5

Any feedback appreciated, thanks!

 

[bbott]

You can use an AND statement. Something like:

=IF(AND(X>=3,X<5),A1,0)

Also, you could combine all of your conditions into one formula, if you'd like.

 

[ChrisS92]

Awesome, that worked. Thanks!