Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago
Solved

Calculated coloumn error

hi   i am getting below error, can you help?  
Need Help
Show and Tell
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi vjnvinod ,

     

    Here is the syntax of IF() function:

    IF(logical_test>,<value_if_true>, value_if_false)

     Now your ture value is a TRUE/FALSE formula, this is why the error occurs. I think you want two conditions, you could use AND(condition1,condition2) or condition1&&condition2 to combine your conditions.

     

v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi vjnvinod ,

 

Here is the syntax of IF() function:

IF(logical_test>,<value_if_true>, value_if_false)

 Now your ture value is a TRUE/FALSE formula, this is why the error occurs. I think you want two conditions, you could use AND(condition1,condition2) or condition1&&condition2 to combine your conditions.