| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine two if formulas into 1 megaformula
These two "if" formulas that work fine on their own. I would like
to combine them into one megaformula in one cell. I have not been able to get it to work. Any help would be appreciated. =IF(AND(WEEKDAY(A4)=2,D4=I1-TIME(1,0,0)),D4+TIME(1,0,0),I1) =IF(AND(WEEKDAY(A4)<2,D4=I2-TIME(1,0,0)),D4+TIME(1,0,0),I2) Thanks, Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine Formulas | Excel Discussion (Misc queries) | |||
| how to combine formulas to......... | Excel Worksheet Functions | |||
| MegaFormula curiosity | Excel Worksheet Functions | |||
| Combine 2 formulas | Excel Worksheet Functions | |||
| Help combine 2 formulas into 1 | Excel Worksheet Functions | |||
Threaded Mode
