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!

- Adding a number to a cell to shift to next cell
- Automatically add "0" to blank cells without a formula in the cel.
- Adding number to a cell reference not to the contents
- Add number to numbers already in a cell (continuing count)
- Add number to cell before aggregation function taken
- Add numbers within a cell
- Need help with macro which adds 1 to the cell below like an autonumbering system?
- Need formula in Excel to substract cell D from Cell C
- Add Comments To A Cell Of 2nd Protected Region
- Add number to duplicated to create unique entry
- How to add button to excel cell with "+" sign
- Need to add data to a cell without overwriting what's there
- A button to add 1 to a cell
- How to add button to excel cell with "+" sign
- Continuously adding to one cell
- Add comment to special cells
- How to copy a formula as text to another cell?
- Need formula to add a number to a cell
- Add number to cells then multiply all
- How to add new data to existing cell based on multiple selective inputs?
- How do I add a set number to a cell's current contents based on a formula?
- Adding number to each cell in a column
- How do you add a new number to each cell in a column
- Adding numbers to cell references in formula, rather than cell values

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?

Thanks,

Kevin

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.

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 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

Thanks

I need to add numbers within a cell. for example...one of the cells is a total of a range of cells..say total is 43...now 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.

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.

cell C. I have worked with Lotus but not Excel before.

Thank you. Louise

VB:Can anyone please advise?Range) '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.AddComment Target.Comment.Visible = False Target.Comment.Text Text:="" & Chr(10) & "" End IfIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Cheers.

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:

JohnSmith

JohnSmith2

JohnSmith3

JaneDoe

JaneDoe2

JohnAdams

JohnAdams2

JohnAdams3

JohnAdams4

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!!

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.

to what's there not overwrite 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

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 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 MsgBox Else '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 'UNCOMMENTThanks in advance

Ajay

I'm sure it's really easy- but I can't figure it out.

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.

or

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.

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.

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

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.