Thread: combining formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
egarcia egarcia is offline
external usenet poster
  
Posts: 13
Default combining formulas
Is there a way to combine both these formulas into one.

IF(AND(Worksheet!N358=TRUE,Worksheet!N360=TRUE,Wor ksheet!N355=TRUE,Worksheet!N376=TRUE),SUM('Summary Sheet'!M34:M42),

IF(AND(Worksheet!N358=TRUE,Worksheet!N360=TRUE,Wor ksheet!N355=TRUE,Worksheet!N376=FALSE),SUM('Summar y Sheet'!M34:M42),

Reply With QuoteReply With Quote