Forum Discussion
Solved
IFS formula gives #N/A error
Hello, I have a simple IFS formula in my sheet. Its job is to look for a certain value in a certain range, if found it should return a specified value. And it does it's job at the first logical te...
=IFS(COUNTIFS($H$3:$H$30,LEFT(B3,4)),$H$2,COUNTIFS($I$3:$I$18,LEFT(B3,4)),$I$2,TRUE,"no match")
Correct. My problem is that when i use IFS on a IFS formula, i get #N/A
Which exactly formula returns #N/A ?
- The formula below gifs the #N/A
=IFS(E118=0;"5";E118=1;"4";E118=2;"3")
It tries to get the outcome of the formula below
=IFS(F118=0;"0";F118=0,5;"1";F118=1;"1";F118=1,5;"1";F118=2;"2";F118=2,5;"3";F118=3;"0")
If it's possible i can also upload the excel document with formulaSorry, another option if you have something what not in criteria options, e.g. E118 = 999. You may change on
=IFS(E118=0;5; E118=1;4; E118=2;3; TRUE; "no such number")Yes, sample file will be great.
Mentioned formula could return #N/A if only in E118 you have text, not number. Perhaps in E118 you have another formula which returns texts instead of numbers.
- I don't know how to ad a sample file