Thread: Help Please
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Help Please

On Sat, 25 Aug 2007 14:38:38 +0100, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

... which of course means that if a formula refers to a constant within the
range, that term will be divided by 41^2, and if there are further
references from one cell to another, that term will be divided by increasing
poweres of 41.


I think the only way to avoid that, if, indeed, the OP wants to avoid it, would
be to convert all to constants.
--ron