combine two formula in one cell

's Computer Specifications

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))

's Computer Specifications

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)),IF(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))

's Computer Specifications

Mrugesh,

=IF(OR(E42="s417t401-43",E42="s417t401-44"),DATE(YEAR(G42)+15,MONTH(G42),DAY(G42)),IF(OR(E42="123411-12",E42="123411-15"),DATE(YEAR(G42)+10,MONTH(G42),DAY(G42)),"None
matched"))

HTH,
Bernie
MS Excel MVP

"Mrugesh Shah" <(E-Mail Removed)> wrote in message
news:A2A1BFA9-9734-42A6-A83B-(E-Mail Removed)...
> 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))

's Computer Specifications

Thank you, but how do I get it to calculate years based on the contents in
cell E42?

"Joel" wrote:

> 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)),IF(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))

's Computer Specifications

Thank You

"Bernie Deitrick" wrote:

> Mrugesh,
>
> =IF(OR(E42="s417t401-43",E42="s417t401-44"),DATE(YEAR(G42)+15,MONTH(G42),DAY(G42)),IF(OR(E42="123411-12",E42="123411-15"),DATE(YEAR(G42)+10,MONTH(G42),DAY(G42)),"None
> matched"))
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "Mrugesh Shah" <(E-Mail Removed)> wrote in message
> news:A2A1BFA9-9734-42A6-A83B-(E-Mail Removed)...
> > 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))
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do i combine text and formula calculation in same cell	gsm	Microsoft Excel Worksheet Functions	5	27th Oct 2009 07:53 PM
How do I combine a VLOOKUP formula and a NETWORKDAYS formula?	Tracy	Microsoft Excel Worksheet Functions	2	15th Oct 2009 04:14 PM
Combine Formula and Data Validation List in a Single Cell ??	monir	Microsoft Excel Worksheet Functions	3	2nd Mar 2008 11:17 PM
How do I combine text and formula within the same cell?	Office	Microsoft Excel Misc	2	26th Feb 2008 02:32 PM
Combine Date cell with Time Cell in one cell	M P	Microsoft Excel Discussion	2	1st Jun 2006 04:09 AM