Formula

[smilingjohn]

Hi All,

Can please someone explain me  how does this below formula works ? 

=if(if(Count(DISTINCT Department)=0,Count(DISTINCT [Sub Dept]),Count(DISTINCT Department))=1,1,0)

Thanks in Advance

[zhadrakas · Accepted solution]

this should help

=if(
   if(Count(DISTINCT Department)=0, //0 Departments, then
       Count(DISTINCT [Sub Dept]),  //count distinct sub department, else
         Count(DISTINCT Department) //count distinct department
    )=1                             //check if result of inner if 1, then
      ,1                            //1, else 
       ,0)                          //0