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
|