Forum Discussion

Shavocky's avatar
Shavocky
Copper Contributor
Mar 07, 2019
Solved

Problems with IFS calculation

Hi, Is it possible to run the IFS function logical test in 2 different cells, e.g., =IFS(A1="X",B1="Y",TRUE,"Z"). I attach a basis example of what I'm trying to achieve. I have only filled in Projec...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 08, 2019

    I modified a bit

    =IFS(D$16=$B2,$C2,ISNUMBER(C17),C17+1,TRUE,"")

    Please see second sheet in attached

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 08, 2019

I modified a bit

=IFS(D$16=$B2,$C2,ISNUMBER(C17),C17+1,TRUE,"")

Please see second sheet in attached

 

  • Shavocky's avatar
    Shavocky
    Copper Contributor
    Mar 08, 2019

    Thanks Sergei, that's exactly the solution I was looking for.