Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula (excel 2000)

    Edited by HansV to format data in table

    Hello, I have two user entered dates in two cells, these dates then determine values used in a formula where the values sit in a table on another page in the book. The formula is A - B/B. What kind of syntax would I use for A and B to be looked up fom my table, my table is a list of figures with the months of the year along the horizontal and the year down the vertical. For example
    <table border=1><tr><td align=right>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula (excel 2000)

    Can you try to explain that again? What is the result you want to get?

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula (excel 2000)

    Hi, assume value A is Feb 87 and Value B is Feb 88 the math would be 4 - 2/ 2. The users would be keying in dates elsewhere in the spread sheet driving the formula in a.n.other cell. By entering Feb 87 in A cell this would then look up Feb 87 value from the table and simarly with B.

    Thanks again Darren.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula (excel 2000)

    Why would you want to compute B/B? That always results in 1, so the outcome of A - B/B is the same as A - 1.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula (excel 2000)

    In fact, I suspect that you do not want A - B/B, but (A - [img]/forums/images/smilies/cool.gif[/img]/B. There is a difference in mathematics and in Excel: multiplication and division have precedence above addition and subtraction, so if you write A - B/B, this means compute B/B first, and only then subtract the result from A. If you want to subtract first, you must use parentheses to make this explicit.

    Perhaps you can use the attached, although it is hard to tell what you actually want.

  6. #6
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula (excel 2000)

    thanks Hans, yes I was very lax with my math, I do mean (A-[img]/forums/images/smilies/cool.gif[/img]/B.

    Thanks Darren.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •