Forum Discussion
IFS function not working
Hello, I recently brought a spreadsheet over to a new laptop and the IFS statements that I had been using are no longer recognized. I get the #NAME? error in all cells that are currently using th...
Please help me, my IFS function is not working.
=ifs(E13>0,"5",E13<-2.5,"4",E13<-5,"3",E13<-7.5,"2",true,"1")
why do i always get's a 4 result ?
Hi Tour,
That's separate topic, better to start new conversation in such case.
As for the function, IFS works till first TRUE condition. If E13 is -10 it's definitely less than -2.5, condition TRUE and formula returns 4/
Hey I figured it out my self after 2 hours...
I've had to switch the other way around...
=ifs(E13<-8,A$17,E13<-6,A$16,E13<-4,A$15,E13<-2,A$14,E13>0,A$13)
start from the smallest first
and it's working
Tour From Bali Thanks. this helped a lot. i switched my data from great to small and worked great.
yes, exactly
