Results 1 to 2 of 2

Thread: IF Formula

  1. #1
    Neophyte Jodie's Avatar
    Join Date
    Jan 2022
    Posts
    1
    Articles
    0
    Excel Version
    2016

    IF Formula



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

    Iím looking for help with a formula that will only do calculation based on if there is data in a cell. Example: ColumnA is an enrollment date but is only used if position is filled. ColumnB is a date 10 years after enrollment date. Can I do a formula that only happens if column A has been populated and leave blank if not? (I donít want it to come up as false).This type of formula I will hopefully manipulate for other columns as needed.Thanks,Jodie

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,938
    Articles
    0
    Excel Version
    O365
    Yeah, you specify "" for false condition, e.g.

    =IF(A2<>"",DATE(YEAR(A2)+10,MONTH(A2),DAY(A2)),"")

Posting Permissions

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