cancel
Showing results for 
Search instead for 
Did you mean: 

Compute Formula If condition?

H369199
NiCd Battery

Compute Formula If condition?

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
H369199
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
marthamiller_SE
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