Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Changing Formulas
Right now I have the following
A1 =DATA!A3 B1 =DATA!B3 C1 =IF(DATA!C8=""."".DATA!C8) D1 =IF(DATA!D8=""."".DATA!D8) Is there any way to change the formulas in C1 & D1 to read =IF(DATA!C3""."".DATA!C3) & =IF(DATA!D3=""."".DATA!D3) other than manually changing them? Thanks in advance for any help! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Changing Formulas
If you cange them to what you show they will not work! DATA!C1"" will return
an error. On the other hand Select the cells C1:D1 and choose Edit, Replace, enter 8 in the Find What box and 3 in the Replace with box and click Replace All. -- If this helps, please click the Yes button Cheers, Shane Devenshire "B.G. - Canada" wrote: Right now I have the following A1 =DATA!A3 B1 =DATA!B3 C1 =IF(DATA!C8=""."".DATA!C8) D1 =IF(DATA!D8=""."".DATA!D8) Is there any way to change the formulas in C1 & D1 to read =IF(DATA!C3""."".DATA!C3) & =IF(DATA!D3=""."".DATA!D3) other than manually changing them? Thanks in advance for any help! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Changing Formulas
This will speed things up, Thanks Shane!
"B.G. - Canada" wrote: Right now I have the following A1 =DATA!A3 B1 =DATA!B3 C1 =IF(DATA!C8=""."".DATA!C8) D1 =IF(DATA!D8=""."".DATA!D8) Is there any way to change the formulas in C1 & D1 to read =IF(DATA!C3""."".DATA!C3) & =IF(DATA!D3=""."".DATA!D3) other than manually changing them? Thanks in advance for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing formulas | Excel Worksheet Functions | |||
changing formulas | Excel Discussion (Misc queries) | |||
Changing formulas | Excel Discussion (Misc queries) | |||
Formulas Changing | Excel Discussion (Misc queries) | |||
Automatic Changing of Formulas | Excel Discussion (Misc queries) |