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)
Since you have quotes around the return values such as "9", the formula returns text, not a number.
Remove those quotes:
=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)
Thank you so much this has now solved the problem!
I only learnt to IF and IFS statements yesterday so i knew it must be something I was doing but I couldn't work it out.