formula not recognizing the null value.

Untitled.png

I am using if formula which refer the another cell value and shows the value in formula cell or shows null value.

Name box D10. formula followed below

=IF(A10>0,(D9+C10),"")

I am using another if formula which calculate the null value.

Name box D11. formula followed below.

=IF(A11>0,(D10+C11),"")

The results at name box D11 is [B]#value!.

as i understand that if formula not recognizing the null value. I advise the solve the issue.

I'm not sure what you mean by "Excel is not recognizing the null value". Excel does not have any means of returning a true Null value (a value that is equivalent to an empty cell) from a formula. In your case, in D10, your formula is returning a null string -- which is still a text string and not numerically equivalent to the value 0. In D11, it attempts to add the value in C11 to the null text string, and Excel does not know how to add a number and a text string. Thus you get the #Value error.

One possible solution is to use the SUM() function instead of the + operator =IF(A11>0,SUM(D10,C11),""). The + operator does not know how to ignore text strings, but the SUM() function does.

Another solution would be to return 0 instead of "", and then use a number format to suppress the display of 0 values =IF(A11>0,(D10+C11),0) formatted as "#,##0;-#,##0;;" (custom number format codes: https://support.office.com/en-us/art...7-9c9354dd99f5 ).

Or any other strategy you can see that will avoid using the + operator to add a text string and a number.