Forum Discussion
#SPILL error
So i am working on a dataset where I am trying to match a set of dates if it falls in a certain date range interval, so whenever I apply a IF(D2>$C$2:$C$4,"pass","fail") formula in D2 (for example), ...
Is the attached example what you are looking for? I entered the formula in E2 and it returns the expected results. I can't enter the formula in D2 because D2 is included in the formula/calculation.
=IF(D2>$C$2:$C$4,"pass","fail")