Free Microsoft Excel 2013 Quick Reference

Simple Formula-Add number to existing cell

I am new to this forum and fairly new to Excel 2003. My question is I need a simple formula that when I enter a numerical value in a cell it will automatically add 4 to it and display the results. One of the cells is C6. I have several cells that the formula will need to be in. I also want the formula not to show in a cell when no value is entered. My second question is how do I protect certain cells from being altered and the other cells can be altered? Just call me Newb! Thanks for all help!

Post your answer or comment

comments powered by Disqus
Okay, this is kind of hard to describe, but will give it a shot.
I have rows of paragraphs of data, and I want to grab the heading of each paragraph. (ie F11, F22, F33, F44, etc...)
Well, I want to say there is a formula that I used before that will allow you to add a number to a cell to shift the cell down (or to the side) and display the value of that cell.
Any ideas?

I use a spreadsheet that generates projected and actual hours/costs. The
projected hours/costs are generated by general support to a team multiplied
by individual monthly support. The hours are multiplied by a hourly rate. I
have a formula that uses projections if the actual cells are blank and if the
actual cells have value it uses the actual info. I have found it necessary
to add 0 to all blank cells during the months close. I update an average of
5,000 entries monthly and would like to find a way to automatically add zeros
to blank cells on demand monthly without adding a formula to the individual
cell as it creates a VALUE error affecting my roll-up hours/costs. I am
wanting to create an on/off type function if possible.

I want to create a formula that will refer to the cell I want by adding a
number to the cell reference, not to the contents of the cell. For example,
lets say that the cell C11 holds a value of 22. I want to add 4 to C11 to
get my formula to reference cell C15, I don't want it to add 4 to the
contents of C11 which is 22 and would give me a result of 26. I have a large
spreadsheet and I can't just fill down the way I have it now and I don't want
to have to retype the formula everytime.

I need a macro that would let me add numbers to numbers already in a cell. I need to keep a continuing count. For example, if 5 is already in the cell and I enter 6 i need the cell to be 11. Also, I have a macro that works for the whole worksheet, but I only need two columns (G,H). Trying to get this report done for work. Thanks!


I have a row of cells that I want to take PRODUCT() on. But before the product is taken I want to add the number 1 to each cell. Can I do this without manually having to add 1 to each cell?

Yes, I am calculating the yearly return on a cells that contain day-to-day return



I need to add numbers within a cell. for of the cells is a total of a range of cells..say total is I need to add 4 + 3 and display the results (7) in another cell.

The book that describes this calculation has refered to it as cross-addition and/or laterally add numbers.

Thanks for your help in advance.

I know it can be done but don't know how to create a macro in Excel to add 1 to the cell below like an autonumber in MS Access.
The table I'm creating will be used to track journals I want the system to generate the next journal number and I want to number to be prefixed with the fiscal year i.e. FY0809.

Very simple question. I need the formula in Excel to substract cell D from
cell C. I have worked with Lotus but not Excel before.

Thank you. Louise

Thanks Dave for his advice on my prior thread. Now I want to allow user to add comments to the cells of column "AH". I use the similar code to do the job but to no avail. I have first locked the whole worksheet and then unlocked the 2 defined regions.

     'First protected region
    If Not Intersect(Target, Range("A1:D100")) Is Nothing Then 
        Me.Protect Password:="Secret", UserInterfaceOnly:=True 
        Target.Locked = True 
        If IsNumeric(Target) Then Target = Target + 1 
    End If 
    Second protected regiion 
    If Not Intersect(Target, Range ("AH1:AH26") Is Nothing Then 'AH1:AH26 has been unlocked beforehand
        Me.Protect Password:="Secret", UserInterfaceOnly:=True 
        Target.Locked = True 
        Target.Comment.Visible = False 
        Target.Comment.Text Text:="" & Chr(10) & "" 
    End If 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Can anyone please advise?

I have looked over the forums for information on how to do this, and can not find anything. I have used conditional formatting to identify duplicates in my spreadsheet. I have a unique user ID, which combines the first and last name fields into one. However, in 10,000 there are a number of John Smiths, Joe Adams, etc. With smaller lists, we search manually, and then add a 1, 2, 3, etc to each duplicate to create a unique value for the User ID.

My question is:

Is there a way to check for duplicates, and then automatically add numbers to the duplicate values to make them unique? If so, how can this be done?

So that you will have this:


I think I have done a good job in illustrating what I would like to be able to do, but if there is still something that is unclear, I will post whatever clarification is needed.

Thank you in advance for your help!!

How to add button to excel cell with "+" sign. I saw a picture with
cell which contains small buttons with "+" sign. And when this button
is pressed new rows are added below the current one. How can I do that?

Is there any way to do that using only excel or I need to use VB and
add buttons for this purpose.

I'm creating a form and I'd like to add data to the cell. I just want to add
to what's there not overwrite it.

I need to create a button that will ADD 1 to a cell everytime I click it.
Actually 3 bottons (1,5,10). I will need to repeat these buttons for 50
students to their total score. I don't know if this matters. I don't mind
creating buttons as long as they're easy to program.
Help Obe Wan

How to add button to excel cell with "+" sign. I saw a picture with
cell which contains small buttons with "+" sign. And when this button
is pressed new rows are added below the current one. How can I do that?

Is there any way to do that using only excel or I need to use VB and
add buttons for this purpose.

I need to continually add numbers to one cell and to have it total in the same cell. For example: Each payday I need to add gross amount of the paycheck to March's income so if one is paid $200. on March 1st, $100. on March 8th, $500. on 15th and etc, I want to have one cell total $800. instead 4 (or 5) seperate cells. Thank you for any help and assistance.


I am highlighting cells with errors ("#N/A") using the code below (else part).
I got an error when trying to add comments to such cells.
How can I modify the code below to add comments to all cells with errors?

'4/5 start if all locations are
"#N/A", Exit program
Dim rErrCheck As Range
'On Error Resume Next           'UNCOMMENT AFTER TEST
With Range("D:D")
Set rErrCheck = .SpecialCells(xlCellTypeFormulas, xlErrors)                    
If Not rErrCheck Is Nothing Then                        
    ' if all errors                        
    If WorksheetFunction.CountA(Range("D2:D" & LastResourceRow)) =  rErrCheck.Count    Then
       '4/23 START highight "#N/A"
       Worksheets(v_resource_sheet_name).UsedRange.SpecialCells(xlCellTypeFormulas, xlErrors).Interior.ColorIndex = 38
'       ' 5/22 add comment
'       Worksheets(v_resource_sheet_name).UsedRange.SpecialCells(xlCellTypeFormulas, xlErrors).AddComment
'       Worksheets(v_resource_sheet_name).UsedRange.SpecialCells(xlCellTypeFormulas, xlErrors).Comment.Text Text:="Pl.
update lookup data for this resource"
'       Worksheets(v_resource_sheet_name).UsedRange.SpecialCells(xlCellTypeFormulas, xlErrors).Comment.Visible = False

        '4/23  END highight "#N/A"
   End If
End If
End With
'On Error GoTo 0                                        'UNCOMMENT
Thanks in advance

Is there an easy way to copy formulas as text to other cells (for use as a

I need a formula to add the number 1 into cell J9 when cell d9 is no longer blank.
I'm sure it's really easy- but I can't figure it out.

I apologize up front for my title but I wasn't sure how to describe.

I have a list of random numbers in column A. The number of rows with data varies day-to-day from 2 rows up to 2000 rows.

I am trying to create a single formula in one cell that is basically two steps. The first step is to add a known number to each row. For example the random number is 1.52 (in cell B1). The last step is to multipy all together.


I know what I want to do, just not how to do it or describe it, so please forgive me if this doesn’t make any sense.

I have a spreadsheet of courses required to reach a certification. On this spreadsheet I have listed the number of hours required for each course in one column, and how many hours I have accrued in an adjoining column. Not all the hours will occur at once, so I tend to bound from cell to cell adding hours in small amounts. What I am trying to do is create a macro that will allow me to add to the existing number of hours to the newly accrued hours, without typing over what is already there.

For example…Class 1 requires five hours total, and I have two hours accrued. If I accrue two more hours (for a total of four hours) I want to update cell E2 without going in to this cell manually and changing this number. I would like to enter the additional two hours in a text box or similar function, and have that function update E2.

To add to the level of difficulty, there are four levels of class. This means not only do I need to be able to select which class hours need updated, but which level of class.

I have attached the spreadsheet I am working with to try to make things a little clearer. I hope.

I think there is a gas leak somewhere in my office because I'm stumped by one of the most basic formulas. I have a spreadsheet that has two columns of dates.

H3 contains a follow up date.

I3 contains an event date.

What I would like to do is simply add 30 days to H3 if I3 contains anything - and if it does not contain anything leave the date alone. The problem I'm having is this is a reference chart, and the dates are not a constant, they are from previous months. The formula =IF(I3<"",I3+30,"") works fine to trigger +30 days if the adjacent event date cell contains anything. However, the problem is it erases the date that was contained in the cell. I think I'm having a brain fart right now and not thinking through this clearly. I assume if I used TODAY() formula, it would reset the cell to the current date each time it's opened, rendering it useless.

How can I add the number "10" to each existing number in a column. More specifically, I have 450 cells in a column that contain different ID numbers. I need to add "10" to the beginning of each of these numbers and any future ID numbers in the column. Is there a simple function to achieve this?

for instance in column c from row 5 to row 455 I want to add .27 to every
number that is already in each cell

example c5 has 9.09 already in it, I want to add .27 for a new total of 9.36

I then want to copy that formula so that it does the same thing all the way
to c455

Hi there,

I currently have text inputs in cells A1, AA1, AB1, AC1 etc.
I would like cells A2, B2, C2, D2 etc. to show these text inputs.

Is it possible to add a number to the cell reference rather than the cell formula which directs the B2 to look 26 cells to the right of cell A1?

Any help is greatly appreciated.

No luck finding an answer? You could always try Google.