+ Reply to Thread
Results 1 to 2 of 2

returning blank cells in an IF function

  1. #1
    Squeky
    Guest

    returning blank cells in an IF function

    I have a function which reads =IF(TODAY()>=A6,C6-B6,"Blank")

    I am trying to have it return an empty cell if the statement is false and I
    can't find to right keyword.

  2. #2
    CLR
    Guest

    Re: returning blank cells in an IF function

    =IF(TODAY()>=A6,C6-B6,"")

    Vaya con Dios,
    Chuck, CABGx3


    "Squeky" <Squeky@discussions.microsoft.com> wrote in message
    news:F2797A04-90F7-45B1-B5D5-AEF01B3F4D35@microsoft.com...
    > I have a function which reads =IF(TODAY()>=A6,C6-B6,"Blank")
    >
    > I am trying to have it return an empty cell if the statement is false and

    I
    > can't find to right keyword.




+ Reply to Thread

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