Thread: match
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default match
=int(yourformulahere)
is one way.

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

--

Dave Peterson
Reply With QuoteReply With Quote