Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing formulas
Can part of a formula - which is a defined name for another cell - be changed
by a find/replace function? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing formulas
Yes.
"xcel user" wrote in message ... Can part of a formula - which is a defined name for another cell - be changed by a find/replace function? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing formulas
Hi Stephen,
thanks for taking the time to respond. I have tried that already - i am using excel 2003 - and excel states it can not find the data. for example - what i want to change is =(acFebTot/a18) to -(acMarTot/a118) thanks again ~ Susan "Stephen" wrote: Yes. "xcel user" wrote in message ... Can part of a formula - which is a defined name for another cell - be changed by a find/replace function? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing formulas
Presumably "acFebTot" is the cell name you have and "acMarTot" is what you
want to replace it with in a formula. I have done this many times using Find/Replace (using versions 2000 and 2003). Are you sure you didn't mistype "acFebTot"? (I notice two typos in your reply below!) "xcel user" wrote in message ... Hi Stephen, thanks for taking the time to respond. I have tried that already - i am using excel 2003 - and excel states it can not find the data. for example - what i want to change is =(acFebTot/a18) to -(acMarTot/a118) thanks again ~ Susan "Stephen" wrote: Yes. "xcel user" wrote in message ... Can part of a formula - which is a defined name for another cell - be changed by a find/replace function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas changing when sorting | Excel Discussion (Misc queries) | |||
Sort changing formulas | Excel Discussion (Misc queries) | |||
Changing formulas | Excel Discussion (Misc queries) | |||
Formulas Changing | Excel Discussion (Misc queries) | |||
Changing values but not formulas | Excel Worksheet Functions |