+ Reply to Thread
Results 1 to 2 of 2

how can avoid considering of blank cells in IF function

  1. #1
    Lika
    Guest

    how can avoid considering of blank cells in IF function

    I am using the following formulas:
    =IF(H8=J8,"1","0")+IF(H10=J10,"1","0")+IF(H12=J12,"1","0")
    but is counting also the blank cells. I would like to compar the cells when
    there are numbers (including zero) inside (not blank).

  2. #2
    Aladin Akyurek
    Guest

    Re: how can avoid considering of blank cells in IF function

    =(COUNT(H8,J8)=2)*(H8=J8)+(COUNT(H10,J10)=2)*(H10=J10)+(COUNT(H12,J12)=2)*(H12=J12)

    Lika wrote:
    > I am using the following formulas:
    > =IF(H8=J8,"1","0")+IF(H10=J10,"1","0")+IF(H12=J12,"1","0")
    > but is counting also the blank cells. I would like to compar the cells when
    > there are numbers (including zero) inside (not blank).


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1