Compute Formula If condition?

[H369199]

Hi,

I am getting an error for the below formula of If condition for multiple columns. Please help me with the correct syntax.

if (@Savings Year@ =2020 OR @Carry Over Year@ =2020 OR @Carry Over Baseline Year@ =2019 OR @Project Status@ ='Awarded', @Annualized Savings@ , 0 )

Regards,
Praveen

[marthamiller_SE]

Hi Praveen - glad you figured it out, that's exactly what I was about to suggest!  The OR condition will return a 'true' boolean value if any of the conditions included are true so putting an "If" statement around that is the most efficient way to solve.

[H369199 · Accepted solution]

Got the solution!!

if (OR(@Savings Year@ =2020, @Carry Over Year@ =2020,@Carry Over Baseline Year@ =2019,@Project Status@ ="Awarded"), @Annualized Savings@ , 0 )