combine two if formulas into 1 megaformula

[Steve]

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

 

[Bob Phillips]

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)

 

[Guest]

What are you trying to combine in them? If formula 1 is false, then use
formula 2... or if A4 is both formula 1 and formula 2, then D4 + Time if true?

 

[Steve]

What are you trying to combine in them? If formula 1 is false, then use
formula 2... or if A4 is both formula 1 and formula 2, then D4 + Time if true?





- Show quoted text -

Thanks for the help guys. I did some rethinking, changed things
around some and wrote the following formula that meets my needs

=IF(WEEKDAY(A4)=2,MAX(I1,D4+TIME(1,0,0)),MAX(I2,D4+TIME(1,0,0)))

Steve