Dear @Kal_Lam, I am trying to build up a calculation question. My aim is to get BSC = sph + cyl/2. Thus, I have built up my form in this way. See attached screenshot
However, the calculation did not perform as I imagined. Besides, the NaN appeared in calculated value. See here
So I am wondering what went wrong here and how can I progress further from here. Attached you find the Excel sheet. Calculation with positive and negative integers.xlsx
(6.6 KB) Thanks in advance for your support.
Welcome to the community, @Sze! Use the
coalesce as outlined in post discussed previously to solve your issue: