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

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

combine two if formulas into 1 megaformula
 

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" wrote:

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

combine two if formulas into 1 megaformula
 

On May 22, 3:42 pm, AKphidelt
wrote:
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" wrote:
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- Hide quoted text -

- 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