View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anne Reichler Anne Reichler is offline
external usenet poster
 
Posts: 2
Default 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?