Forum Discussion
IFS statement with SEARCH not working
The IFS statement below works with the exception of the SEARCH part I've added at the end. If cell C1105 contains 1%, it will work, but if it contains 2% or 4%, it will not work. For some reason any ...
Erin-
It's difficult to tell what you're trying to do with the formula alone. Is there anyway you could please provide a non-sensitive example file to give a little context to your data structure and the particular scenario you currently have. A before and after would be nice as well to help understand what values your current formula is currently yielding and what you would expect it to yield if it was working correctly.