Forum Discussion
Solved
IFS return #N/A with more criteria
Dear All/Hello, I use following formula which brings me the # N/A result IFS ( $V$44 > $O$8 , $X$8 , $V$44 < $P$8 , $X$8 ) On evaluation of formula V44 (parameter) > reference 1 (O8) = FALSE and ...
- I found the solution in a mean time and is working.
Created another row with new formula so the 2nd (middle value) and 3rd (lowest value) criteria can work.
Now my formula is like this =IFS($V$44>=$O$8;$X$8;$V$44<$K$9;$X$9;$V$44>=73;0) ... 73 and higher being the middle value and 2nd criteria.
However, if any another idea comes from you it will be appreciated.
I found the solution in a mean time and is working.
Created another row with new formula so the 2nd (middle value) and 3rd (lowest value) criteria can work.
Now my formula is like this =IFS($V$44>=$O$8;$X$8;$V$44<$K$9;$X$9;$V$44>=73;0) ... 73 and higher being the middle value and 2nd criteria.
However, if any another idea comes from you it will be appreciated.
Created another row with new formula so the 2nd (middle value) and 3rd (lowest value) criteria can work.
Now my formula is like this =IFS($V$44>=$O$8;$X$8;$V$44<$K$9;$X$9;$V$44>=73;0) ... 73 and higher being the middle value and 2nd criteria.
However, if any another idea comes from you it will be appreciated.