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

Options

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

• ✭✭✭✭✭✭
Options

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

• Options

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

• Options

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

Thanks all!

• Options

We are working on a similar sheet!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!