Greater than Less than formula
Maybe
=IF(AND(C22,C2<6),C2,"")
Mike
"Mike" wrote:
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
|