ExcelBanter - Greater than Less than formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Greater than Less than formula (https://www.excelbanter.com/excel-discussion-misc-queries/188035-greater-than-less-than-formula.html)

Mike

Greater than Less than formula

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

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

Mike

Greater than Less than formula

Thanks Mike, this worked perfectly

"Mike H" wrote:

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

All times are GMT +1. The time now is 02:38 AM.