IF/AND formula

I need to calculate the number of Network Days based on a Leave Status but if a half day has been checked, it needs to just put 0.5. The formula I am currently using is:

=IF(AND([Half Day]@row = 1) [Leave Type]@row = "TOIL", "0.5", NETWORKDAYS([Start Date]@row, [End Date]@row))

But I'm getting a #Unparsable error.

What am I doing wrong?

TIA

Cheryl

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

The AND piece is just a little off.

=IF(AND([Half Day]@row = 1, [Leave Type]@row = "TOIL"), "0.5", NETWORKDAYS([Start Date]@row, [End Date]@row))

=Chris Palmer

Hi Cheryl,

Looks like you need some commas and one more parenthesis to initiate the IF AND

Give this a shot and see if it works for you:

=IF(AND([Half Day]@row = 1, [Leave Type]@row = "TOIL"), 0.5, NETWORKDAYS([Start Date]@row, [End Date]@row))

All comments

Paul Newcome

The AND piece is just a little off.

=IF(AND([Half Day]@row = 1, [Leave Type]@row = "TOIL"), "0.5", NETWORKDAYS([Start Date]@row, [End Date]@row))

=Chris Palmer

Hi Cheryl,

Looks like you need some commas and one more parenthesis to initiate the IF AND

Give this a shot and see if it works for you:

=IF(AND([Half Day]@row = 1, [Leave Type]@row = "TOIL"), 0.5, NETWORKDAYS([Start Date]@row, [End Date]@row))

Cheryl C

Perfect, thanks @Mr. Chris @Paul Newcome

Worked perfectly. Knew it would have to be something simple.

Cheryl

=Chris Palmer

Excellent. Glad this worked for you.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.