Re: Amending a Formula

On Thu, 12 May 2011 06:21:30 -0400, Ron Rosenfeld <ron@xxxxxxxxxx> wrote:

On Wed, 11 May 2011 16:29:25 -0700 (PDT), joeu2004 <joeu2004@xxxxxxxxxxx> wrote:

I don't believe that. As written, you have a height of -14. But
height must positive.

You are, of course, correct according to the documentation.

However, and I think this goes back at least to XL98, the OFFSET function has been accepting negative values for both height and width; and the result has been to affect the direction for determining the height or width.

In addition, just to show how MS handles this, there are Knowledge Base articles indicating that this behavior is incorrect! So, although useful, it may not be supported in the future.

Negative values for height and width seem to work OK in XL 2007 SP1 also.

Perusing some MSKB articles, I see this issue applies as far back as Excel 5.0 !!

I don't know if it is present in Excel 2010.
.

Relevant Pages

  • Re: I cant get Excel OFFSET Fnct to return multiple references.
    ... In our case 'Reference' is all of column G, ... Similar to the above you can use the OFFSET function to define a dynamic ... >I am trying to set up dynamic charts for multiple data arrays, ... > create dynamic charts in Excel" in the excel help files? ...
    (microsoft.public.excel.charting)
  • Re: older version and newer version of excel
    ... I know there is no XL2007 for Mac, so I assumed that when the OP said XL98, he was stating the correct version number for a Windows version of Excel... ... Can the 98 version be loaded on her laptop even though> it ...
    (microsoft.public.excel.programming)
  • Re: Userforms???
    ... Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step ... Knowledge Base Articles ... How to Use a UserForm for Entering Data ... "John Baker" wrote in message ...
    (microsoft.public.excel.programming)
  • Re: Is there an excel funtion that retreives the last cell of a list
    ... Since you are on Excel 2003, convert the data area of interest into a list by means of Data|List|Create List. ... The list, or series kees getting longer but I always want to link a cell in a table to the last data of the list, at the end of the list. ... With the offset function it can be done but I was wondering if there was a better function. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: count conditional days - ajit
    ... What is offset function? ... with my excel version. ... > Change the name to suit, the A/P to suit, and the,,1 to reflect the day ... >> I want to calculate how many Sundays, Tuesdays etc. Jack ...
    (microsoft.public.excel.misc)