| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Editing an "IF" function across a worksheet/excel file
Hi
I have about a 1000 formulae using the function "IF" across many worksheets in an excel file. eg: =IF(C13150,ROUND(C1315+15,-1),"") I wish to change the number 15 to 25 across all IF functions in the worksheet and in all worksheets in the file. Is there as easy way to do it ? Any help is appreciated. Thanks for taking the time. Regards Cedric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to unlock a file that is "locked for editing" | Excel Discussion (Misc queries) | |||
| Delete a "locked for editing file by..." | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| "Locked for Editing" error on a non-protected file | Excel Discussion (Misc queries) | |||
| file.xls is locked for editing by "user" | Excel Worksheet Functions | |||
Threaded Mode
