+ Reply to Thread
Results 1 to 3 of 3

IF OR, problem if the reference cell contain formula

  1. #1
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    IF OR, problem if the reference cell contain formula

    Hi

    I have problem with IF OR, if the conditional cell contains IF formula and with empty, excel count the cell as true always
    how to solve it?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,811

    Re: IF OR, problem if the reference cell contain formula

    Any text string (including null string "") is greater than any number, so the greater than tests both return TRUE. You either need to change the formula in column F so that it returns something other than null string (maybe -1 and suppress the display of the negative number using number formatting), or you need to change the formula in column I to test for the null string case and choose accordingly [maybe IF(F1="","",current formula)].

    Will either of those options work?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: IF OR, problem if the reference cell contain formula

    Maybe try

    =IF(OR(D1>1,N(F1)>1),"ok","no")

+ 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. Replies: 3
    Last Post: 03-22-2021, 10:21 AM
  2. Replies: 1
    Last Post: 02-11-2015, 01:56 PM
  3. [SOLVED] Replace absolute cell reference with Indirect cell reference in formula
    By Roothy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-11-2013, 04:46 AM
  4. Replies: 7
    Last Post: 02-03-2013, 06:25 PM
  5. Still having formula reference problem
    By Jiptastic in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-01-2013, 05:07 PM
  6. Replies: 3
    Last Post: 06-16-2011, 02:42 PM
  7. Excel formula cell reference problem
    By ajorlov in forum Excel General
    Replies: 1
    Last Post: 04-03-2009, 04:15 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