Pass/Fail status based on value of one cell being less than or greater than another cell

Peter Thai

Hi All,

Would appreciate some guidance on a formula I'm having trouble with. I would like to create a pass/fail column based on whether the value in a column@row is greater than or less than the value of another column@ row.

Current Formula - =IF(CFUs@row > [Action Level CFU]@row, "Fail", "Pass")

For some reason, I am still getting a "Fail" result when the CFUs@row value is less than the [Action Level CFU]@row value. Please see the highlighted below.

Appreciate the help.

-Peter

Paul Newcome

How exactly is the data being entered into each of the columns?

Peter Thai

The data in the CFU column is entered manually.

The [Action Level CFU] Column is based off the following formula:

=IF(AND([Sample Type (Air/Surface)]@row = "Air", [ISO Class]@row = "ISO 5"), "1", IF(AND([Sample Type (Air/Surface)]@row = "Air", [ISO Class]@row = "ISO 7"), "10", IF(AND([Sample Type (Air/Surface)]@row = "Air", [ISO Class]@row = "ISO 8"), "100", IF(AND([Sample Type (Air/Surface)]@row = "Surface", [ISO Class]@row = "ISO 5"), "3", IF(AND([Sample Type (Air/Surface)]@row = "Surface", [ISO Class]@row = "ISO 7"), "5", IF(AND([Sample Type (Air/Surface)]@row = "Surface", [ISO Class]@row = "ISO 8"), "100"))))))

Peter Thai

Figured it out. I need to move the " " from the number values.

Thanks all!

Kris V. Le

We are working on a similar sheet!