Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
What is the no-pass action, I1 or I2?
=IF(AND(WEEKDAY(A4)=2,D4=I1-TIME(1,0,0)),D4+TIME(1,0,0),IF(AND(WEEKDAY(A4)<2, D4=I2-TIME(1,0,0)),D4+TIME(1,0,0),I2)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Steve" wrote in message ps.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |