Forum Discussion
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 calculate A-B, if A is empty then it is automaticaly defaut as 0, which turn out the result is wrong.
Please help! Thanks
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~
2 Replies
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~