| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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), |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combining formulas
Try this:
=IF(AND(Worksheet!N358=TRUE,Worksheet!N360=TRUE,Wo rksheet!N355=TRUE,OR(Worksheet!N376={TRUE,FALSE})) ,SUM('Summary Sheet'!M34:M42),"NO Data") -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "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), |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combining formulas
Hi,
Maybe: =IF(AND(Worksheet!N358=TRUE,Worksheet!N360=TRUE,Wo rksheet!N355=TRUE,OR(Worksheet!N376=TRUE,Worksheet !N376=FALSE)),SUM('Summary Sheet'!M34:M42),0) HTH Jean-Guy "egarcia" wrote: 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), |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combining formulas
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), |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combining formulas
Try this:
=IF(AND(Worksheet!N358=TRUE,Worksheet!N360=TRUE,Wo rksheet! 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 On Feb 6, 7:21 pm, egarcia wrote: Is there a way to combine both these formulas into one. IF(AND(Worksheet!N358=TRUE,Worksheet!N360=TRUE,Wor ksheet!N355=TRUE,Workshee*t!N376=TRUE),SUM('Summar y Sheet'!M34:M42), IF(AND(Worksheet!N358=TRUE,Worksheet!N360=TRUE,Wor ksheet!N355=TRUE,Workshee*t!N376=FALSE),SUM('Summa ry Sheet'!M34:M42), |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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), |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combining formulas
hello again Valko,
FOR ME, you are sensitively right. -- ***** birds of the same feather flock together.. "T. Valko" wrote: 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), |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combining formulas
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 "driller" wrote in message ... hello again Valko, FOR ME, you are sensitively right. -- ***** birds of the same feather flock together.. "T. Valko" wrote: 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), |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combining formulas
surely we cannot disregard the blank cells in this case... -- ***** birds of the same feather flock together.. "T. Valko" wrote: 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 "driller" wrote in message ... hello again Valko, FOR ME, you are sensitively right. -- ***** birds of the same feather flock together.. "T. Valko" wrote: 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), |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining formulas | Excel Discussion (Misc queries) | |||
| how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
| combining countif formulas | Excel Worksheet Functions | |||
Linear Mode
