Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Need Help - Calculation Column with blank value (Newbie)

I would like to calcualtion as the excel formula =IF(OR(AY2="",AX2=""),"",AY2-AX2). Below is the result in excel.    However, when I apply the same logic, it give me error below. If I just ca...
  • xifeng_L's avatar
    xifeng_L
    2 years ago

    Hi Anonymous ,

     

    Please change the second parameter of IF from "" to BLANK().

     

    Because the data types of the calculated columns must be the same. In the original IF function, the second parameter was empty text, while the third parameter was numerical, so there were more than one data type, which is called variant type, which is not allowed in the calculated column.

     

     

     

    Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

     

    Thank you~

xifeng_L's avatar
xifeng_L
Icon for Super User rankSuper User
2 years ago

Hi Anonymous ,

 

Please change the second parameter of IF from "" to BLANK().

 

Because the data types of the calculated columns must be the same. In the original IF function, the second parameter was empty text, while the third parameter was numerical, so there were more than one data type, which is called variant type, which is not allowed in the calculated column.

 

 

 

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

 

Thank you~