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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!