Page 2 of 2 FirstFirst 1 2
Results 11 to 18 of 18

Thread: Roundup

  1. #11


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Thanks guys! Got it figured out and learned a lot!

  2. #12
    Here is another question for you guys. I have the formula =(DATE(YEAR(E5), MONTH(E5), DAY(E5)+20) but I want to add to it an IF statement. I would like to say that if E5 is blank that I can have the phrase "enter date" in that field. I tried using =IF(E5>0,"Enter Date","Enter Date") but it didnt work. What am I doing wrong? Thanks again!

  3. #13
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    194
    Articles
    0
    Excel Version
    2010
    =IF(E5="","Enter date",E5+20)
    should do it.
    This website wants to know your momentum - | Deny | | Allow |

  4. #14
    Unfortunately no, it didnt work.

  5. #15
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    194
    Articles
    0
    Excel Version
    2010
    In what way?
    This website wants to know your momentum - | Deny | | Allow |

  6. #16
    I think what he wants is:

    =IF(ISNUMBER(E5),DATE(YEAR(E5), MONTH(E5), DAY(E5)+20,"Enter a date")

    It doesn't actually check if it's a date but is functionally the same as checking the value vs 0.

    Jesse

  7. #17
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    194
    Articles
    0
    Excel Version
    2010
    Is 0 not a number?
    All that Date stuff is still unnecessary - just add 20.
    This website wants to know your momentum - | Deny | | Allow |

  8. #18
    vs GREATER than zero :P

    Good call on the date, I totally skipped over that. You're totally right, just ignore the last thing I said. Must have had some bad coffee........

    Jesse

Page 2 of 2 FirstFirst 1 2

Posting Permissions

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