Formula error

I am currently using Microsoft Excel 2013 on a Windows 10 computer.

I have this formula that I thought will give me a blank result if a range of cells are blank and continue to another formula if the cells have a “value” in them.

This is the formula:


However, it’s giving me a #VALUE! result instead. What is wrong with my formula?


By: Carl

Leave a Reply

Your email address will not be published. Required fields are marked *