Forum Discussion

Jennifer Miller's avatar
Jennifer Miller
Copper Contributor
Apr 13, 2018

Formula fix needed

See attached Screen Capture.  I need assistance with the formula in K2.  

 

1. If J2 is blank, K2 should be blank.  If J2 is populated with a date, then look at G2:

............if G2 = "ANNUAL" and "RFP", I would like for K2 to be the sum of J2 +21 days.

............if G2 = "ITB", I would like for K2 to be the sum of J2 + 28 days

............if G2 = "RFQ", I would like for K2 to be the sum of J2 +14 days.

 

Correct help would be greatly appreciated...I can't seem to master the formula!

Formulas & Functions
Need Help
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Apr 14, 2018

    Hi Jennifer,

     

    This is the formula you need in cell K2:

    =IF(J2="","",
  IF(OR(G2="ANNUAL",G2="RFP"),J2+21,
  IF(G2="ITP",J2+28,
  IF(G2="RFQ",J2+14))))

     

    I hope this helps you

    Haytham

Resources