+ Reply to Thread
Results 1 to 3 of 3

in this TRUE OR FALSE function, i want desired name instead of display true or false

  1. #1
    Forum Contributor
    Join Date
    09-19-2013
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    252

    in this TRUE OR FALSE function, i want desired name instead of display true or false

    i need to compare D1 = E1 , formula should be in F1,

    if true value comes, then i desired cell should be blank,

    if false value comes, then i will like to display "CHECK STATUS"

  2. #2
    Valued Forum Contributor
    Join Date
    10-29-2012
    Location
    Mojokerto,Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    554

    Re: in this TRUE OR FALSE function, i want desired name instead of display true or false

    =if(d1<>e1,"check status" ,"")

  3. #3
    Forum Contributor
    Join Date
    09-19-2013
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    252

    Re: in this TRUE OR FALSE function, i want desired name instead of display true or false

    Wow its working, thanks a lot, and i have a similar question, pls find this excel and solve this problem also,

    compare two COLUMN and display if any numbers in first column and second column is blank then display Desired word,

    all others should be blank, pls help us..
    Attached Files Attached Files

+ 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. Display true false with IF formula
    By pcoutlaw in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-22-2012, 09:48 AM
  2. Compare two excel files and display true or false
    By sravanthi009 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-01-2011, 11:36 AM
  3. True/False indicator to display in different sheet
    By HPD in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-07-2007, 06:26 AM
  4. Replies: 3
    Last Post: 07-15-2006, 05:20 AM
  5. [SOLVED] Function to return True/False if all are validated as True by ISNU
    By Tetsuya Oguma in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2006, 06:30 AM

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