1. 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. Re: Formula (excel 2000)

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

3. 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. 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. 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. 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
•