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