Calculation with positive and negative integers does not work and "NaN" appearing

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:

1 Like