Trouble Using Nested IF Formula
Results 1 to 3 of 3

Thread: Trouble Using Nested IF Formula
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2014
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Trouble Using Nested IF Formula

    Hi all,
    I am trying (unsuccessfully) to create an IF statement that does the following:

    In cell S2 If The week number in H2 is Greater than Todays date then write "Late" If not write nothing, If H2 has nothing in it then keep the cell (S2) blank.

    I am probably way off but I tried the following: IF(H2<$T$1, "Late", IF(H2="","")). I would appreciate any assistance!

    Many thanks

  2. #2
    Board Regular RudiS's Avatar
    Join Date
    May 2015
    Location
    Cape Town, RSA
    Posts
    349
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Trouble Using Nested IF Formula

    Try this:
    = IF(H2="","",IF(H2>WEEKNUM($T$1), "Late",""))
    =======
    Regards
    Rudi

  3. #3
    New Member
    Join Date
    Jul 2014
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Trouble Using Nested IF Formula

    Quote Originally Posted by RudiS View Post
    Try this:
    = IF(H2="","",IF(H2>WEEKNUM($T$1), "Late",""))
    Genius!
    Thank you so much - it works a treat.


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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