Hoping one of you might be able to help me with a couple of formulas I want to combine into one.
The first one looks up a cell with a date in it and returns a date 5 days in advance, unless the cell is empty, then it returns 'no date'.
=IF(E38="","no date",WORKDAY(E38,5))
Second one is similar but checks whether the text 'review' appears in another cell before returning a date 3 days in advance or 'no date'.
=IF(ISNUMBER(FIND("review",C38)), WORKDAY(E38,3), "no date")
I tried combining them (below), but I'm not great at nesting stuff and Excel was having none of it.
=IF(OR(E38="","no date",WORKDAY(E38,5)),(ISNUMBER(FIND("review",C38), WORKDAY(E38,3), "no date")))
Any suggestions?
EDIT:
Neither of the below formulas seem to work either:
=IF(OR("no date"),IF(ISNUMBER(FIND("review",C38)),WORKDAY(E38,3),WORKDAY(E38,5)))
=IF(OR(IF(ISERROR(SEARCH("review",C38)),"no date",WORKDAY(E38,5))),IF(ISNUMBER(FIND("review",C38)),WORKDAY(E38,3),WORKDAY(E38,5)))
I think I'm starting to not see the wood for the trees with this.