Instead of putting these formulas in two separate cells how can I combine them so that both can be in the same cell. The possibility of both being true is 0.
=IF('PM Base'!I52="","",IF('PM Base'!D60="","Schedule Call Log",""))
and
=IF('PM Base'!I76="","",IF('PM Base'!D85="","Schedule Call Log",""))
and
=IF('PM Base'!I101="","",IF('PM Base'!D111="","Schedule Call Log",""))
Tags: