Pass/Fail status based on value of one cell being less than or greater than another cell
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
Answers

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

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"))))))

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

We are working on a similar sheet!
Help Article Resources
Categories
Check out the Formula Handbook template!