Simple Formula-Add number to existing cell

**Bamaborn** · 05-03-2010, 07:58 PM

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!

**davesexcel** · 05-03-2010, 08:03 PM

This can be done with VBA and is why it has been moved to Excel Programming

**Simon Lloyd** · 05-03-2010, 08:09 PM

Typing in to a cell that has a formula will erase the fomula which is why Dave says it can only be done with VBA.

As for protecting cells, you need to unlock all cells (CTRL+A, right click, format cells, protection, uncheck the locked check box) then select the cells taht you want locked and perform the action again, then protect the worksheet.

**Bamaborn** · 05-03-2010, 08:37 PM

That helped. Thank you. What is VBA?

**davesexcel** · 05-03-2010, 08:40 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!