Treat N/A as zero within an IF formula

Please can someone help me fix this formula?


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 it is text value then can try-


Leave a Reply