I have a very long nested IF and IFS formula that works fine.However, if I go back to it and change anything, even just a number, it displays text and not the result.The cell format doesn't change, it is not set to display formulas - the only difference is I changed 12 to 13.good formula displays result=IF($J11="bicycle",IFS(AND($L11>=14,$L11<17),12,AND($L11>=16,$L11<20),14,AND($L11>=18,$L11<22),16,AND($L11>=22,$L11<25),20,AND($L11>=24,$L11<28),24,$L11>=28,26,$L11="",LISTS!M$13),"")formula displays as text now after changing bold number=IF($J11="bicycle",IFS(AN