combine two if formulas into 1 megaformula
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
|