View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AKphidelt AKphidelt is offline
external usenet poster
 
Posts: 461
Default 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