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:

=IF(E24:F35=””,””,IF(COUNTIF(E24:F35,”OK”)>11,”PASS”,”FAIL”))

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

Thanks!

By: Carl

Leave a Reply

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