Compute Formula If condition?

Highlighted
NiCd Battery
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
Labels (1)
0 Kudos
2 Replies
Highlighted
NiCd Battery
Got the solution!!

if (OR(@Savings Year@ =2020, @Carry Over Year@ =2020,@Carry Over Baseline Year@ =2019,@Project Status@ ="Awarded"), @Annualized Savings@ , 0 )
0 Kudos
Highlighted
NiCd Battery
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.
0 Kudos