Skip to main content
Topics#Data ManagementPergunta de N G
N G (ANC) perguntou em #Data Management
22 de jun. de 2020, 09:47

Need help with formula

Hi everyone,

 

Need help with Formula:

 

It's a huge formula, getting compile size error.

 

Formula that I built:

 

 

IF(
AND (M= TRUE,N= FALSE,V= FALSE,C= FALSE,A= FALSE),"M",
IF(
AND (M= TRUE,N= FALSE,V= TRUE,C= FALSE,A= FALSE), "M+V",
IF(
AND (M= TRUE,N= TRUE,V= FALSE,C= FALSE,A= FALSE),"M+N",
IF(
AND (M= FALSE,N= TRUE,V= FALSE,C= FALSE,A= FALSE),"N",
IF(
AND (M= FALSE,N= FALSE,V= TRUE,C= FALSE,A= FALSE),"V",
IF(
AND (M= FALSE,N= TRUE,V= TRUE,C= FALSE,A= FALSE),"V+N",
IF(
AND (M= TRUE,N= TRUE,V= TRUE,C= FALSE,A= FALSE),"M+V+N",
IF(
AND (M= FALSE,N= FALSE,V= FALSE,C= TRUE,A= FALSE),"C",
IF(
AND (M= FALSE,N= FALSE,V= FALSE,C= FALSE,A= TRUE),"A",
IF(
AND (M= TRUE,N= TRUE,V= TRUE,C= TRUE,A= FALSE),"M+V+N+C",
IF(
AND (M= FALSE,N= TRUE,V= TRUE,C= TRUE,A= FALSE),"V+N+C",
IF(
AND (M= FALSE,N= FALSE,V= TRUE,C= TRUE,A= FALSE),"V+C",
IF(
AND (M= FALSE,N= TRUE,V= FALSE,C= TRUE,A= FALSE),"N+C",
IF(
AND (M= TRUE,N= TRUE,V= FALSE,C= TRUE,A= FALSE),"M+N+C",
If(
AND (M= TRUE,N= FALSE,V= TRUE,C= TRUE,A= FALSE),"M+V+C",
IF(
AND (M= TRUE,N= FALSE,V= FALSE,C= TRUE,A= FALSE),"M+C",
If(
AND (M= TRUE,N= TRUE,V= TRUE,C= TRUE,A= TRUE), "M+V+N+C+A",
If(
AND (M= FALSE,N= TRUE,V= TRUE,C= TRUE,A= TRUE),"V+N+C+A",
IF(
AND (M= FALSE,N= FALSE,V= TRUE,C= TRUE,A= TRUE),"V+C+A",
If(
AND (M= FALSE,N= TRUE,V= FALSE,C= TRUE,A= TRUE),"N+C+A",
IF(
AND (M= TRUE,N= TRUE,V= FALSE,C= TRUE,A= TRUE),"M+N+C+A",
IF(
AND (M= TRUE,N= FALSE,V= TRUE,C= TRUE,A= TRUE),"M+V+C+A",
IF(
AND (M= TRUE,N= FALSE,V= FALSE,C= TRUE,A= TRUE),"M+C+A",
If(
AND (M= TRUE,N= FALSE,V= FALSE,C= FALSE,A= TRUE),"M+A",
IF(
AND (M= TRUE,N= TRUE,V= FALSE,C= FALSE,A= TRUE),"M+V+A",
IF(
AND (M= TRUE,N= TRUE,V= FALSE,C= FALSE,A= TRUE),"M+N+A",
If(
AND (M= FALSE,N= TRUE,V= FALSE,C= FALSE,A= TRUE),"N+A",
IF(
AND (M= FALSE,N= FALSE,V= TRUE,C= FALSE,A= TRUE), "V+A",
IF(
AND (M= FALSE,N= TRUE,V= TRUE,C= FALSE,A= TRUE),"V+N+A",
IF(
AND (M= TRUE,N= TRUE,V= TRUE,C= FALSE,A= TRUE),"M+V+N+A",""
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)

 

what is does is, whatever is true from N,V,A,C,M need to show it as text in result.
3 respostas
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    22 de jun. de 2020, 09:58
    Hi,

     

    I assume they're all checkboxes. If so, try this:

    SUBSTITUTE( 
    IF(N, "N+", NULL)+
    IF(V, "V+", NULL)+
    IF(A, "A+", NULL)+
    IF(C, "C+", NULL)+
    IF(M, "M+", NULL)+".", "+.",NULL)

     

     
Escrever uma resposta...
0/9000