Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Change formulae easily?
I have to change a great amout of formulae from a simple
=A3/A4 to either =ROUND(A3/A4,0) or =IF(A4=0,"",A3/A4) The cells are spread all over the sheet, sometimes in one row or line, sometimes grouped together or sometimes individually placed anywhere on the sheet. Is there an easy way to change these formulae faster then individually change each cell? Even changing each cell individually would be easier if there was a way to wrap the old formula between the necessary alteration. (PS: ASAP has a Macro that can alter the formula, but it can only add something at the end and the formula is lost and the new value is shown.) |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Change formulae easily?
Why not Find/Replace?
Look in Formulas (not values) and Find A3/A4 and replace with ROUND(A3/A4,0) or whatever "fak119" wrote in message ... I have to change a great amout of formulae from a simple =A3/A4 to either =ROUND(A3/A4,0) or =IF(A4=0,"",A3/A4) The cells are spread all over the sheet, sometimes in one row or line, sometimes grouped together or sometimes individually placed anywhere on the sheet. Is there an easy way to change these formulae faster then individually change each cell? Even changing each cell individually would be easier if there was a way to wrap the old formula between the necessary alteration. (PS: ASAP has a Macro that can alter the formula, but it can only add something at the end and the formula is lost and the new value is shown.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recalculation of formulae disabled | Excel Discussion (Misc queries) | |||
Formulae or format to change a number "1" into the word "one | Excel Discussion (Misc queries) | |||
How do I create charts that change source data automatically? | Charts and Charting in Excel | |||
Can't change x-axis labels | Charts and Charting in Excel | |||
Change to formulae | Excel Worksheet Functions |