Formula for Different Calculations within one cell

I am attempting to determine spending, depending on the project status. I thought maybe the IF THEN formula would help, but I kept receiving errors when writing the formula.

Project (Column A)

Status (Column B)

Cost (Column C)

Spent (Column D)

Based on the status provided in Column B, I'd like Column D to calculate Column C differently. For Example, if the status is "Planning", then Column D should take the Column C*0. If the status is "Pre-Production"=Column C*0.5, "Production"=Column C*0.7, "Completed"=Column C*1

Find more posts tagged with

Accepted answers

All comments

NickStaffordPM

Can you post the formula that was giving you an error? This will help me understand the logic you need

Jenn W.

Here's what I tried based on an AI suggestion. However, this always produces the answer 0, no matter what the status is.

=IF([Current_Risk_Status]@row = "Planning", [2024 - Gross]@row * 0, IF([Current_Risk_Status]@row = "Pre-Production (50%)", [2024 - Gross]@row * 0.5))

Jenn W.

Oh - I think it's working now! I missed a " in the formula in my sheet, but typed it here!!! Sometimes all it takes is to type it out.

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.