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

Find more posts tagged with

Accepted answers

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.