Forum Discussion
Solved
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...
=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.
=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.
Thank you so much, that is perfect!