Formula for Different Calculations within one cell

Jenn W.

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

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.