Returning An Integer From A List Of Fractional Numbers
Returning An Integer From A List Of Fractional Numbers I have searched relentlessly and, incredibly, have not been able to solve what seems to be an almost childish formula dilemma. To keep it simple: A column of numbers all having fractional values, example: D 1 13.8 2 3.3 3 24.1 4 13.2 5 16.1 6 28.1 7 16.2 The list can be phrased either as D1:D7 or as a defined table. I want to return a true statement if the integer: 13, only (no fractional values), is found in this list. Of course, it can be seen to appear twice, but once is enough to do the job. I've tried applying TRUNC and INT functions to various convolutions of MATCH and INDEX functions, but no success. How about =NOT(ISERROR(MATCH(13,D1:D7,0))) ? – Robin Mackenzie Jul 2 at 0:56 =NOT(ISERROR(MATCH(13,D1:D7,0))) It's a good idea ...