Results 1 to 2 of 2

Thread: maybe an OR formula?

  1. #1
    Neophyte cmautry's Avatar
    Join Date
    May 2021
    Posts
    1
    Articles
    0
    Excel Version
    office 365

    maybe an OR formula?



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

    Please help if you can. I'm sure this is much easier than I think. I need help with a formula in "D"


    A - Date of Placement B - Date Plan Due C - Date Plan Approved D - Review Due
    1/1/2021 this is the date in "A" +45 this is a date or the cell is blank I need either the date in C +150 OR if the C is blank, I need something like "Out of Compliance"


    Does this make sense? Can anyone help?

    Thanks!
    Christina Autry
    Chandler, TX

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,661
    Articles
    0
    Excel Version
    Office 365 Subscription
    Maybe a simple IF:

    =IF(C1="","Out of Compliance",C1+150)
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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