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),
|