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