Forum Discussion
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. ...
Thank you so much, can i add an or to this so if C3 is Major Overdue or Overdue to make it 30?
OR, you may CHOOSE this formula:
=CHOOSE(OR(C3={“Major Overdue”,”Overdue”})+1,
TODAY()-B3,
30)
=CHOOSE(OR(C3={“Major Overdue”,”Overdue”})+1,
TODAY()-B3,
30)