+ Reply to Thread
Results 1 to 3 of 3

If formula blank error

  1. 05-15-2012, 02:34 PM #1
    eddienole
    eddienole is offline
    Registered User
    Join Date
    07-29-2011
    Location
    Charlotte
    MS-Off Ver
    Excel 2010
    Posts
    26

    If formula blank error

    =if(I5="","",If(I5=Y,C5))
    C5 would be a date and I5 would be blank or a Y. My formula is in cell J5. IF I5 is Y I want J5 to return the date in C5, but I keep getting #NAME? with this formula.
    I've also tried =if(isblank(I5),"",IF(I5=Y,C5)) and get the same error message.
    Thanks in advance for the help.
    Reply With QuoteRegister To Reply
  2. 05-15-2012, 02:38 PM #2
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: If formula blank error

    How about

    =IF(I5="Y",C5,"")
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
  3. 05-15-2012, 02:43 PM #3
    eddienole
    eddienole is offline
    Registered User
    Join Date
    07-29-2011
    Location
    Charlotte
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: If formula blank error

    Thank you. I tried to make it more complicated than needed.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1