+ Reply to Thread
Results 1 to 4 of 4

Empty cell result

  1. #1
    Forum Contributor
    Join Date
    10-18-2017
    Location
    london
    MS-Off Ver
    2007
    Posts
    152

    Empty cell result

    hi my friends..

    i use a formula for identify cell with same number
    if cell is same number formula say OK
    if cell is not same number formula say NO

    trouble:

    empty cell formula say OK


    formula is in J column and correct result in K column

    how adjust formula for correct K column result?

    thanks..
    Attached Files Attached Files

  2. #2
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Empty cell result

    Hi
    Try this
    =IF(D3="","",IF(D3=F3,"OK","NO"))

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,967

    Re: Empty cell result

    You can use this formula:

    =IF(D3&F3="","",IF(AND(D3=F3,D3=F3),"OK","NO"))

    then copy down.

    Hope this helps.

    Pete

  4. #4
    Forum Contributor
    Join Date
    10-18-2017
    Location
    london
    MS-Off Ver
    2007
    Posts
    152

    Re: Empty cell result

    thnanks friends...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Show cell empty if result is an error due to empty source
    By jackmcguigan1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2016, 09:54 AM
  2. Replies: 1
    Last Post: 05-30-2015, 08:31 AM
  3. [SOLVED] Show result Cell as Empty If.....
    By JRidge in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-24-2014, 04:56 AM
  4. [SOLVED] Can a formula result in an 'empty' cell?
    By Cloth Ears in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 10-01-2014, 11:17 PM
  5. Replies: 6
    Last Post: 09-16-2010, 05:19 AM
  6. show empty cell if result is more than 20
    By fargobride in forum Excel General
    Replies: 4
    Last Post: 10-24-2009, 09:14 PM
  7. is statement with an empty cell as result
    By RDM in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-02-2005, 01:06 PM

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