Treat N/A as zero within an IF formula

Please can someone help me fix this formula?

=-IF(D11="Cash",D9,D14*12)

The issue I have is that when ‘cash’ is selected in D11, cell D14 shows N/A – is there a way to make excel treat N/A as a zero when ‘cash’ is selected.

Many thanks

>Solution :

If this is error value then can use IFERROR() function like-

=-IF(D11="Cash",D9,IFERROR(D14,0)*12)

If it is text value then can try-

=-IF(D11="Cash",D9,IF(D14="N/A",0,D14)*12)

Leave a Reply