Results 1 to 9 of 9

Return blank if Cell is blank or contains formula)

Threaded View

  1. #1
    Registered User
    Join Date
    12-21-2010
    Location
    Vancouver
    MS-Off Ver
    Excel 2007
    Posts
    83

    Return blank if Cell is blank or contains formula)

    Im trying to return a "" if L2 is blank. However L2 contains a formula which returns blank if a test is not met. So my formula bellow does not work because the cell is blank only to the eye, it actually contains a formula.


    =IF(L2="","",IF(L2<800,"Y","N"))

    I tried

    =IF(ISTEXT (L3),"",IF(L3<800,"Y","N"))

    but did not work

    Any help much appreciated.

    Thanks
    Last edited by oo0tommyk0oo; 12-28-2010 at 06:29 PM.

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