| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add a value to the cell value itself
I have a value in a cell.I want to add a value to the cell value on 1st
January of every year.How to do it? Example: as on 31st January Cell B2=17 I want a formula to add 30 to B2 cell on 1st January result on 1st January in Cell B2=47 What formula works? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200907/1 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add a value to the cell value itself
Typo error:Please correct 31st January to 31st December
tkraju wrote: I have a value in a cell.I want to add a value to the cell value on 1st January of every year.How to do it? Example: as on 31st January Cell B2=17 I want a formula to add 30 to B2 cell on 1st January result on 1st January in Cell B2=47 What formula works? -- Message posted via http://www.officekb.com |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add a value to the cell value itself
Look he
http://www.mcgimpsey.com/excel/accumulator.html -- Kind regards, Niek Otten Microsoft MVP - Excel "tkraju via OfficeKB.com" <u16627@uwe wrote in message news:98c69e66f6d20@uwe... I have a value in a cell.I want to add a value to the cell value on 1st January of every year.How to do it? Example: as on 31st January Cell B2=17 I want a formula to add 30 to B2 cell on 1st January result on 1st January in Cell B2=47 What formula works? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200907/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'IF' Macro to insert cell contents to alternate cell if cell not e | Excel Worksheet Functions | |||
| Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
| How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
| Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Linear Mode
