Multiple IF AND Nesting Formulas

Trying to return a number based on the GVWR column, we have multiple GVWR's and want to return differnt numbers in the TARE column. I keep getting a syntax error and can't figure out why. Ultimately there will be 5 options, showing two below. It works with one IF formula.

=IF(GVWR@row = 9500, 5840), IF(AND(GVWR@row = 9950, 6740))

Find more posts tagged with

Accepted answers

All comments

Cory Page

@Steve_B1 Good morning, I am sure we can come up with something for you but I need a bit more information. Would you be able to share a screenshot of the sheet, dummy data is fine it helps a lot.

Also in the TARE column, what are the 5 options you would like to add, in the above formula there isn't anything defined if true other than another if(and statement so I am not sure what should populate if the first if is satisfied.

Thanks,

JamesB

@Steve_B1

Where are you wanting your TRUE/FALSE to live in your equation? Right now you have if =IF(GVWR@row = 9500, 5840) is true then run another if. IF you are wanting the statement to be True based on both GVWR statements being true, then you need to move your AND statement.

=IF(AND(GVWR@row = 9500, GVWR@row = 9950),"5840,6740",FALSE)

Steve_B1

Steve_B1

Here is the whole formula with all 5 options

=IF(AND(GVWR@row = 6050, 6050), IF(AND(GVWR@row = 6500, 6500), IF(AND(GVWR@row = 9500, 5840), IF(AND(GVWR@row = 9950, 6740), IF(AND(GVWR@row = 10360, 6770))))))

Cory Page

@Steve_B1 Gotcha, the and was throwing me off there a bit sorry about that..

Is this what you're looking for?

=IF(GVWR@row = 6050, "6050", IF(GVWR@row = 6500, "6500", IF(GVWR@row = 9500, "5840", IF(GVWR@row = 9950, "6740", IF(GVWR@row = 10360, "6770")))))

Steve_B1

Yes, thank you! I thought "" were only necessary for text.

Cory Page

Yea, you dont have to use the "" its habit I was going to update the post but I figured if you asked I would just reply. If you want a number just leave the "" off, my mistake..

Steve_B1

Great, thanks again for the help!

JamesB

@Cory Page Thank you. I was away, but the clarification on the use of the AND statement definitely helped.

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.