View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default combining formulas

If N376 is empty it will evaluate to FALSE.

Biff

"T. Valko" wrote in message
...
Try it like this:

=IF(AND(N358=TRUE,N360=TRUE,N355=TRUE,N376<"",OR( N376={TRUE,FALSE})),SUM(M34:M42),"")

Biff

"egarcia" wrote in message
...
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),