| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula arithmetic
see ans in functions. Pls don't multipost
-- Don Guillett SalesAid Software "R" wrote in message ... Hi folks, I'm sure the question has come-up before so please bear with me. Here is the basic problem: I have a formula that looks something like this: =sheetname!$E$101 What I want to do is change the cell reference from 101 to 105, i.e. add 4 to the numerical part of the formula. Any ideas? I have hundreds of these formulas that need changing and I would prefer to do a global change rather than do all these manually. Thanks a lot. -R |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date arithmetic | Excel Discussion (Misc queries) | |||
| Excel 2007 Arithmetic | Excel Discussion (Misc queries) | |||
| About arithmetic Formulas | Excel Discussion (Misc queries) | |||
| Simple arithmetic | Excel Discussion (Misc queries) | |||
| Simple arithmetic - take 2 | Excel Discussion (Misc queries) | |||
![Don Guillett[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
