Forum Discussion
Solved
Using IFS statements not working
Hi Please can anyone help. I am trying to use IFS statements to be able to compare data from two different columns. For example I want to say IF A3<B3 return "Below" IF A3=B3 return "Met" IF...
LucyPEOffice The formula you shared in column AT is returning text strings, not numbers. "9" is a text string... 9 is a number. This is what I was hinting at in my first reply about cells containing numbers formatted as text. Try ditching the double-quotation marks in your formula to see if that solves it...
=IFS(AQ3>=158,9,AQ3>=135,8,AQ3>=120,7,AQ3>=106,6,AQ3>=91,5,AQ3>=69,4,AQ3>=46,3,AQ3>=23,2,AQ3>=0,1)
Formula seems correct. You may have extra hidden characters to your data.