Forum Discussion
Issues with IFs And Formula
I have been Trying to get the correct formula for Hours and keep getting a False Error when I add the true and false out put in.
I'm not seeing the problem here. It might be that IFS works different than IF? IFS does not have a 'false' output per se. The format is IFS( condition1, if-true-1, condition2, if-true-2, ....) SO to get a 'false' output or default output I use a TRUE and then what I want so IFS( a=b, c, TRUE, d ) so if a=b then it will output c but if NOT then it goes to the NEXT condition which in this case is TRUE which means it will output d.