Results 1 to 13 of 13

Populate same Cell with 2 possible out comes with If(isblank)

Threaded View

  1. #1
    Registered User
    Join Date
    02-18-2021
    Location
    Bamber Bridge
    MS-Off Ver
    Microsoft 365
    Posts
    17

    Populate same Cell with 2 possible out comes with If(isblank)

    Hi,
    I am trying to populate a cell (R3) with 2 possible out comes, although I can't work out how to do it. Both formulas are below and are required in cell (R3). Basically if (T3) is populated with a date (R3) returns a completed statement, but I also require (R3) to return a blank cell if (S3) is not populated with a date.

    =IF(ISBLANK($T3),$S3+365,"Completed")
    =IF(ISBLANK($S3),"",$S3+365)

    Any help would be appreciated.

    Kevin.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Cell with 0 characters but FALSE =ISBLANK
    By SHI.NL in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-19-2018, 05:42 AM
  2. [SOLVED] ISBLANK therefore go to next cell
    By KDHY in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-31-2015, 02:52 PM
  3. [SOLVED] isblank inappropriate for more than 1 cell?
    By Butcher1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-11-2014, 03:24 PM
  4. ISBLANK w/ Formula in target cell
    By grantpank in forum Excel General
    Replies: 2
    Last Post: 08-29-2011, 06:12 PM
  5. Help with ISBLANK function referring to a cell with another ISBLANK formula
    By camdameron in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-23-2011, 12:45 PM
  6. ISBLANK function and Cell range
    By AndyF19 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2010, 09:33 AM
  7. Can you test for a range (Q16:19) any cell is ISBLANK
    By CRayF in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2005, 02:05 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