| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy & pasting formulas across workbook tabs
I have a formula that doesn't calculate correctly when I copy and paste it
across tabs in a workbook. The formula is : =if(iserror(O17/O15),0,(O17/O15)). However when I type it in each cell it will work correctly. There are many instances of this formulas and many tabs and to have to type each one will take way too much time. Does anyone know why this is happening and have suggestions on fixing? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Pasting formulas | New Users to Excel | |||
| Can you copy multiple tabs from formulas to values w/o paste spec? | Excel Worksheet Functions | |||
| Copy tabs(sheets) from workbook without link to original source | Excel Discussion (Misc queries) | |||
| Copy tabs(sheets) from workbook without link to original source | Links and Linking in Excel | |||
| How to copy formulas from one workbook to another | Excel Discussion (Misc queries) | |||
Threaded Mode
