Hello, I've wrecked my brain trying to figure out the formula just to add 50% to the returned value. I got close but it seems to be off by a few dollars. I also will need to use this in an IF formula. If Express Check = N then =SUM[Column2]@row - 5000) * 0.64 + 11002.5 total is 11017.86 * My formula =SUM([Column2]@row - 5000) * [Column2]3 + [Column2]4 If Express Check = Y then 50% needs to be added to 11017.86 I was first trying to figure out how to add the 50% to returned value and this is as far as I got: * My formula =SUM(SUM([Column2]@row - 5000) * [Column2]3 + [Column2]4) + ([Column2]@row - 5000) * [Column2]3 + [Column2]4 * 0.5 I hope this makes sense.

Need help with an IF statement / Add 50% to formula result

Hello,

I've wrecked my brain trying to figure out the formula just to add 50% to the returned value. I got close but it seems to be off by a few dollars. I also will need to use this in an IF formula.

If Express Check = N then =SUM[Column2]@row - 5000) * 0.64 + 11002.5 total is 11017.86

My formula =SUM([Column2]@row - 5000) * [Column2]3 + [Column2]4

If Express Check = Y then 50% needs to be added to 11017.86

I was first trying to figure out how to add the 50% to returned value and this is as far as I got:

My formula =SUM(SUM([Column2]@row - 5000) * [Column2]3 + [Column2]4) + ([Column2]@row - 5000) * [Column2]3 + [Column2]4 * 0.5

I hope this makes sense.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try something like this...

=(SUM([Column2]@row - 5000) * [Column2]3 + [Column2]4) * IF([Column Name]1 = "Y", 1.5)

Basically what this does is initially runs your base calculation. Then if the cell = "Y" it will multiply it by 1.5 (which adds 50%). If the cell does not equal "Y", then it just leaves the base calculation.

Rosa Crisostomo

Thanks, Paul! The formula added 50% if checked yes, but when I change the Express Check = N, it zeros out the results opposed to doing the basic calculation.

Paul Newcome

That sort of makes sense. Let's try this... If it is "Y" then multiply by 1.5, otherwise multiply by 1.

=(SUM([Column2]@row - 5000) * [Column2]3 + [Column2]4) * IF([Column Name]1 = "Y", 1.5, 1)

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.