Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    May 2002
    Posts
    36
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Help with IF formula to return a null value if cer (2000)

    Post deleted by sbdale

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    199
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Help with IF formula to return a null value if cer (2000)

    Hi,

    You stated, "The problem I'm having is if both start date and end dates cells are empty" - I suspect you may really mean "if either start date OR ending date cells are empty". On that basis try the following:

    =IF(OR(H11="",I11=""),"",IF(DAYS360(H11,I11)<1,1,D AYS360(H11,I11)+1))

    Good Luck!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •