Forum Discussion

Cableguy918's avatar
Cableguy918
Copper Contributor
Dec 20, 2023

IFS only pulling one of three criteria

Having trouble getting IFS function to read the the options I have listed and for some reason it is only acknowledging this first. I'm not getting errors, just pulls the first option for all three va...
  • OliverScheurich's avatar
    Dec 20, 2023

    Cableguy918 

    =IFS(D6>=99,50, D6>=74,40,D6>=49,25,TRUE,0)

     

    The IFS formula returns the first result for which the condition is TRUE. For the value 99 condition D6>=99 is true therefore result is 50. For the value 74 condition D6>=74 is true therefore result is 40 and so on.

Resources