Forum Discussion

SPearson1973's avatar
SPearson1973
Copper Contributor
Jun 04, 2019

Excel If or formula?

I have a formula which looks at a date in column B and returns how many days from that date - thi s formula is  =Today()-B3, I have another column with Text which states Major Overdue or other text. ...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 04, 2019

SPearson1973 , if your text is in C3 that could be

=(30-TODAY()+B3)*(C3="Major Overdue")+TODAY()-B3

or

=IF(C3="Major Overdue",30,TODAY()-B3)

 

SPearson1973's avatar
SPearson1973
Copper Contributor
Jun 04, 2019

SergeiBaklan 

Thank you so much, can i add an or to this so if C3 is Major Overdue or Overdue to make it 30?

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Jun 04, 2019
    OR, you may CHOOSE this formula:
    =CHOOSE(OR(C3={“Major Overdue”,”Overdue”})+1,
    TODAY()-B3,
    30)
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 04, 2019

    SPearson1973 , yes, sure, you may wrap both options with OR, alternatively use 

    =IF( ISNUMBER(SEARCH("Overdue",C3)), 30, TODAY()-B3)

    Condition returns TRUE if the word Overdue will be within any text in C3.

    Same with the other formulas above.

     

Resources