IF Formula

I'm trying to set up a formula to calculate merit increases but, I keep getting "#UNPARSEABLE" in my cell. Can someone tell me what I am doing wrong? thank you!

=if([Salary Per]@row ="Hourly",[Proposed Hourly Rate]@row *2080, if([Salary Per]@row ="Annually",[Current Salary Rate]@row *(1+[Increase Percentage Salary]@row ,""))))

Find more posts tagged with

if formula

Accepted answers

All comments

Anjanesh Vaidya

Hi @HRrmc

Please use the formula below, it will work 👍
There is a syntax error in your current formula.

=IF([Salary Per]@row = "Hourly", [Proposed Hourly Rate]@row * 2080, IF([Salary Per]@row = "Annually", [Current Salary Rate]@row * (1 + [Increase Percentage Salary]@row ), ""))

amarkumar

@HRrmc hi

You’re getting #UNPARSEABLE because the parentheses/commas in your second IF are off—your multiplication term accidentally includes an extra ,"" inside it.

Use this corrected formula:

=IF([Salary Per]@row = "Hourly", [Proposed Hourly Rate]@row * 2080, IF([Salary Per]@row = "Annually", [Current Salary Rate]@row * (1 + [Increase Percentage Salary]@row ), ""))

A couple quick checks:

Make sure the text values match exactly: "Hourly" and "Annually" (spelling/case/spaces).
[Increase Percentage Salary]@row should be stored as a percent (e.g., 5%) or a decimal (0.05)—your math assumes that.

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.