Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mass Forumla Change
Hi,
I have a large number of formulas that link from one work sheet to the other which also use IF functions. Is there a quick way to change the IF criteria (say from "1" to "2") for all the formulas at once? Cheers G |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mass Forumla Change
G,
Select the cells, press Ctrl-h, then type in the find something that is completely unique about the formula. For example: =IF(A1=1,This,That) You would want to replace =1 and not just 1 so that you don't change the cell references as well, and then for the replace with, use =2 And click Options, and choose the lookin Formulas option. HTH, Bernie MS Excel MVP "Ghalmaraz" wrote in message ... Hi, I have a large number of formulas that link from one work sheet to the other which also use IF functions. Is there a quick way to change the IF criteria (say from "1" to "2") for all the formulas at once? Cheers G |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forumla Help- Change Column value not row | Excel Discussion (Misc queries) | |||
when i change data in a sum forumla, the sum doesn't change? | Excel Discussion (Misc queries) | |||
when i change data in a sum forumla, the sum doesn't change? | Excel Discussion (Misc queries) | |||
Mass Change Across Many WorkBOOKS | Excel Discussion (Misc queries) | |||
mass change table_array Name in VLOOKUP formula | Excel Worksheet Functions |