Comparing Three Columns

I have three columns that I want to compare. I thought an If(and( statement would do it but I keep getting #incorrect argument or #unparsable errors.

Each column is a dollar amount and I basically want if Column 1 < Column 2 and Column 3 return a value.

Below is the expression I've been trying.

=IF(AND([EXTENDED COST 3]@row <= [EXTENDED COST 2]@row , [EXTENDED COST 1]@row , "Green", "Red"))

This feels like it should be simple and I'm missing something.

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Give this a try:

=IF(AND([EXTENDED COST 1]@row <= [EXTENDED COST 2]@row, [EXTENDED COST 1]@row <= [EXTENDED COST 3]@row), "Green", "Red")

All comments

Paul Newcome

Give this a try:

=IF(AND([EXTENDED COST 1]@row <= [EXTENDED COST 2]@row, [EXTENDED COST 1]@row <= [EXTENDED COST 3]@row), "Green", "Red")

apnkc1137

That gets me a result. I think I see how you had to separate the arguments. Thank you very much.

Paul Newcome

Happy to help. 👍️

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.