Forums

General Betting

There is currently 1 person viewing this thread.
redrich
11 Nov 09 12:24
Joined:
Date Joined: 12 Dec 04
| Topic/replies: 3,599 | Blogger: redrich's blog
How do you put a fixed cell into a formula?

I've got = (D3-B3)*J6

and I want all formulas as we go down the column to read

(D4-B4)*J6
(D5-B5)*J6
(D6-B6)*J6
(D7-B7)*J6

etc....

i.e. I want the row in each formula to go up by one, but the J6 to say the same rather than ending up with:


(D4-B4)*J6
(D5-B5)*J7
(D6-B6)*J8
(D7-B7)*J9

etc

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
sort by:
Show
per page
Replies: 2
By:
mc selecta
When: 11 Nov 09 12:26
put $J$6 as the cell.

The $ fixes the following row/column reference.
By:
redrich
When: 11 Nov 09 12:30
Brilliant

thank you
sort by:
Show
per page

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
‹ back to topics
www.betfair.com