Help
Join Now
Remember me
Forgot your
username
/
password
?
Safer Gambling
Exchange
Sportsbook
Virtual Sports
Betfair Community
Everything
Forums
Blogs
Search
launch community pop-up
Home
›
General Betting Forum
›
Spreadsheet help please
Switch to Community Classic
App Directory
Forums
Forum - How To Join
Announcements
Service
New Products and Features
Forum Chat
Site Feedback
Sports
Football
Horse Racing
Ante Post Racing
Bloodstock & Breeding
US Racing
Cheltenham Festival
Grand National
Golf
Cricket
Tennis
Cycling
Darts
Rugby
Snooker
Greyhounds
Australian
American Football
Basketball
Boxing
Mixed Martial Arts
Irish Sports
Motor Sports
Poker
Games
Other
Specials
General Betting
Chit Chat
Politics
Tradefair & Financials
Your Competitions
Developers
Labs Chat
Help Forum
Guidelines
Terms & conditions
General Betting
Forum
General Betting Blogs
Welcome to Live View – Take the tour to learn more
Start Tour
‹ back to topics
There is currently 1 person viewing this thread.
Spreadsheet help please
This user is offline.
redrich
Date Joined:
12 Dec 04
Add contact
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
Pause
Play
•
Switch to Standard View
Spreadsheet help please
Show More
Report
mc selecta
•
November 11, 2009 12:26 PM GMT
put $J$6 as the cell.
The $ fixes the following row/column reference.
put $J$6 as the cell.The $ fixes the following row/column reference.
Report
redrich
•
November 11, 2009 12:30 PM GMT
Brilliant
thank you
Brilliantthank you
Post Your Reply
Text Format:
Table:
Smilies:
Remove
said
<CTRL+Enter> to submit
<Enter> to submit
Post Reply
↵
Please login to post a reply.
Wonder
Instance ID: 13539
launch community pop-up
www.betfair.com
Betfair