combine two if formulas into 1 megaformula

S

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
 
B

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)
 
A

AKphidelt

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?
 
S

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 -
Click to expand...



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
 
Top