IF OR Question

I'm trying to calculate a Total Amount column where if the Type field is either Faculty or EMT then the Total Amount equals Total Meals * 100 (each meal costs $100), but otherwise is $0. I keep getting errors with this:

=IF(OR(Type@row, "Faculty", Type@row, "EMT", [Total Meals]@row * 100, 0))

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @Barent Wagar

I hope you're well and safe!

Try something like this.

=IF(OR(Type@row, "Faculty", Type@row, "EMT"), [Total Meals]@row * 100, 0)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Barent Wagar

Thanks! I'm still getting an "Invalid Data Type" error.

Andrée Starå

@Barent Wagar

Happy to help!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Leibel S

@Barent Wagar

See below:

=IF(OR(Type@row = "Faculty", Type@row = "EMT"), [Total Meals]@row * 100, 0)

Andrée Starå

@Leibel Shuchat

Good catch! I missed it, and just noticed the missing parenthesis.

@Barent Wagar

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Barent Wagar

That last one worked, thanks so much!

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.