Nesting a formula in an 'if' statement - conditional values

I have two reimbursement schemes for staff vs. managers for an expense, and am using a 'checkbox' to identify managers when submitting a claim. Managers will have a 'checked' checkbox in that column.

I'm trying to use in a IF statement to behave in the following manner and can't get the syntax right.

I'm striving for, in words, "If the Manager column is checked, multiply the [Number of Nights] column in the same row by an amount, if not true, value is $0. This plays into another formula that sums the 'claims' but catches this 'top up' for managers.

=IF([Manager]@row = 1, "([Number of Nights]@row*25)", "0")

Any tips appreciated.

Thanks,

Adam

Find more posts tagged with

Accepted answers

All comments

Purnima Gore

Use True to make the formula work

=IF(Manager@row = "True", Nights@row * 25, 0)

Hope that helps

Purnima

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.