It's due to the logic in his previous question.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"JLatham" wrote in message
...
I'm going to have to ask why you're trying to divide the results of MATCH
by
anything?
MATCH does not return the value of a thing, it returns the position number
that the match found in the list. You're getting the .5 when match finds
the
match at items 1, 3, 5, ... any odd number in your list.

But to provide a solution to your question, try one of these, first one
using INT will alway cause a value ending in .5 to become just the whole
number portion (i.e. 1.5 = 1, 2.5 = 2, 3.5 = 3, etc)
=INT(MATCH(A33,F7:F15,0)/2)

This one will always round up to next larger integer, as 1.5 = 2, 2.5 = 3,
etc.
=ROUNDUP(MATCH(A33,F7:F15,0)/2,0)


"RobcPettit" wrote:

Hi, can I modify the formula =MATCH(A33,F7:F15,0)/2 so that it only
give whole number results. Eg not 1.5,2.5,3.5 but 1,2,3.
Regard Robert