set formula to display a data from a 5 columns table
Hi
Try amending Gary's formula to
=OFFSET(A1,(ROUNDUP(A8/1000,0)),ROUNDDOWN((A9/10)-0.1,0)+1)
--
Regards
Roger Govier
"David" wrote in message
...
"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"
|