I am trying to assign values based on the following scenario:
If the value of a cell is >= "D24", then x. If false, then y. D24 is the value, not a reference to a particular cell. The formula I am using is:
=IF(L3>="D24", "X","Y")
Formula works fine for values D1 and D2, but D3-D9 return "X" instead of "Y". Values above D24 work fine. Suggestions?
Bookmarks