# Writing a simple function and only need to increase the value of one cell.

1. ## Writing a simple function and only need to increase the value of one cell.

So I'm calculating a relatively simple function, however, I can't get the value of the B cell to increase without increasing the others. Example, I want excel to create the following cell contents when I highlight the cells and drag them down.

``Please Login or Register  to view this content.``
All I want to do is increase B8 to B9 to B10 to B11 etc. How do I go about this?

2. ## Re: Writing a simple function and only need to increase the value of one cell.

Formula:
`Please Login or Register  to view this content.`

make them absolute with \$\$ just select say b1 in the formula and hit f4 it toggles =\$A\$1 =A\$1 =\$A1 =A1
see here
http://www.cpearson.com/excel/relative.aspx

3. ## Re: Writing a simple function and only need to increase the value of one cell.

Thank you so much! Seriously, you made my night! This worked perfectly.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1