| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combine two formula in one cell
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)) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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)) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combine two formula in one cell
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)),"Non e matched")) HTH, Bernie MS Excel MVP "Mrugesh Shah" wrote in message ... 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)) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combine two formula in one cell
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)),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)) |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combine two formula in one cell
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)),"Non e matched")) HTH, Bernie MS Excel MVP "Mrugesh Shah" wrote in message ... 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)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i combine text and formula calculation in same cell | Excel Worksheet Functions | |||
| How do I combine a VLOOKUP formula and a NETWORKDAYS formula? | Excel Worksheet Functions | |||
| Combine Formula and Data Validation List in a Single Cell ?? | Excel Worksheet Functions | |||
| How do I combine text and formula within the same cell? | Excel Discussion (Misc queries) | |||
| How do I combine an if and min formula? | Excel Worksheet Functions | |||
Linear Mode
