IF formula

Can someone tell me what I am doing wrong with this formula? If the checkbox is checked, I need the value to be zero, if it is not checked then I need the formula to work:

=IF([Existing current WJA server]@row = 1, 0, IF([Existing current WJA server]@row = 2, [How many WebJet Admin Server Instances required?]@row * 4))

Find more posts tagged with

Accepted answers

SoS | Dan Palenchar

I'm assuming that "Existing current WJA server" is your checkbox column. If so, I would try the below formula.

=IF([Existing current WJA server]@row = 1, 0, [How many WebJet Admin Server Instances required?]@row * 4)

All comments

SoS | Dan Palenchar

I'm assuming that "Existing current WJA server" is your checkbox column. If so, I would try the below formula.

=IF([Existing current WJA server]@row = 1, 0, [How many WebJet Admin Server Instances required?]@row * 4)

Stacy Stoffel

Thank you so much! I thought i tried that...I must have had that second IF in place.

SoS | Dan Palenchar

@Stacy Stoffel You're welcome! Technically the second IF would still have worked if the argument was set to be equal to 1 (you had = 2 which is not a value for a checkbox), but better to be as efficient as possible in my opinion!

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.