In the following code (in column V) when U18 is equal "" I get a value of zero when I expected a "" null value. This causes a problem in sorting.
[code] =IF($U18="",$H18,"X"){/CODE]
Both col U and H are defined as "General", however I've tried changing both to "Text" with same result.
I appreciate any suggestions.
Thanks
Bookmarks