Results 1 to 6 of 6
Thread: Formula (excel 2000)

20040727, 14:52 #1
 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>

20040727, 14:53 #2
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 28 Times in 28 Posts
Re: Formula (excel 2000)
Can you try to explain that again? What is the result you want to get?

20040727, 14:57 #3
 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.

20040727, 15:01 #4
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 28 Times in 28 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.

20040727, 17:53 #5
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 28 Times in 28 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.

20040727, 20:08 #6
 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.