Forum Discussion
Solved
IFS Shows #VALUE! instead of actual value
Cannot determine why #VALUE! is shown instead of 201. Per help on IFS, the value should be returned for the first TRUE response which in this case is shown for Logical_test2 - T...
See the attached version.
IFS() check till first TRUE condition and skips FALSE condition. If no one TRUE condition is met formula returns #N/A error. However, if !VALUE# is result of checked condition, entire formula returns !VALUE# as well.
In your case the workaround is to use ISNUMBER(FIND(...)) instead of FIND(). But better formula HansVogelaar suggested.
Thank you very much Sergei! I will try the ISNUMBER per your suggestion. Thanks again!!!