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

17 thoughts on “Formula error

  1. tinyurl.com

    Normally I do not read post on blogs, however I wish to say that this write-up very compelled me to
    take a look at and do it! Your writing style has been surprised me.
    Thanks, quite great post.

  2. quest bars cheap

    Greetings! I’ve been reading your website for some time now and finally got the courage to go ahead and give you a
    shout out from Kingwood Texas! Just wanted to say keep up the great job!

  3. ps4 games

    naturally like your web-site however you have to check the spelling on quite a few of your posts.

    A number of them are rife with spelling issues and I find it very bothersome to tell the truth nevertheless I will definitely come back again.

  4. ps4 games

    I don’t even know how I ended up here, but I thought this post
    was great. I do not know who you are but definitely you are going
    to a famous blogger if you are not already 😉 Cheers!

  5. sling tv

    I know this website gives quality depending articles and
    extra material, is there any other website which presents these kinds of information in quality?

  6. tinyurl.com

    Heya i am for the first time here. I came across this board
    and I find It really useful & it helped me out much.
    I hope to give something back and help others like you helped
    me.

  7. sling tv

    I’m not that much of a internet reader to be honest but your sites really nice, keep it up!

    I’ll go ahead and bookmark your website to come back in the future.
    Cheers

  8. ig

    whoah this weblog is magnificent i love reading your articles.
    Keep up the good work! You realize, lots of individuals are searching around for this
    information, you could help them greatly.

Leave a Reply

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