combining formulas

E

egarcia

Is there a way to combine both these formulas into one.

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

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

Ragdyer

Try this:

=IF(AND(Worksheet!N358=TRUE,Worksheet!N360=TRUE,Worksheet!N355=TRUE,OR(Worksheet!N376={TRUE,FALSE})),SUM('Summary
Sheet'!M34:M42),"NO Data")
 
P

pinmaster

Hi,

Maybe:

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

HTH
Jean-Guy
 
T

T. Valko

Try it like this:

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

Biff
 
P

Pete_UK

Try this:

=IF(AND(Worksheet!N358=TRUE,Worksheet!N360=TRUE,Worksheet!
N355=TRUE),SUM('Summary Sheet'!M34:M42),"not specified")

It doesn't seem to matter what the value of Worksheet!N376 is. Also,
you have not specified what to do if the AND( ) function returns
FALSE.

Hope this helps.

Pete
 
T

T. Valko

That's why I included: N376<>""

and, at the same time, if N376 = 0 (number)

OR(N376={TRUE,FALSE})

Still evaluates to FALSE,FALSE

In this case the number 0 <> FALSE

but an empty cell which evaluates to 0 = FALSE

Biff
 
Top