Greater than Less than formula

Mike · May 19, 2008

I am trying to create an if then formula for the following but am having some
difficulty. Any assistance would be appreciated.

If C2 is greater than 2 but less than 6 than it equals C2.

Mike

Mike H · May 19, 2008

Maybe

=IF(AND(C2>2,C2<6),C2,"")

Mike

Mike · May 20, 2008

Thanks Mike, this worked perfectly

Mike H said:
Maybe

=IF(AND(C2>2,C2<6),C2,"")

Mike