combine two formula in one cell
I connected the two formulas using an OR, you may want an AND
=OR(IF(OR(E42="s417t401-43",E42="s417t401-44"),DATE(YEAR(G42)+15,MONTH(G42)+0,DAY(G42)+0)),I F(OR(E42="123411-12",E42=123411-"15"),DATE(YEAR(G42)+10,MONTH(G42)+0,DAY(G42)+ 0)))
"Mrugesh Shah" wrote:
How do I combine these two formulas for result in one cell
=IF(OR(E42="s417t401-43",E42="s417t401-44"),DATE(YEAR(G42)+15,MONTH(G42)+0,DAY(G42)+0))
=IF(OR(e42="123411-12",E42=123411-15"),date(year(G42)+10,month(g42)+0,day(g42)+0))
|