View Single Post
  #3   Report Post  
Old June 22nd 08, 07:16 PM posted to microsoft.public.excel.setup
David David is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,560
Default set formula to display a data from a 5 columns table



"Gary''s Student" wrote:

=OFFSET(A1,ROUNDDOWN((A9/10)-0.1,0),(ROUNDUP(A8/1000,0)+1))

--
Gary''s Student - gsnu200793


Thanks you for your answer. I tried but got some wrong return. Did I enter
something wrong? I enter 900 in A8 and 10 in A9. The display in A10 is
"11-20 day"