Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 7th 07, 09:10 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2007
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?

  #2   Report Post  
Old June 7th 07, 09:25 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 3,268
Default Copy & pasting formulas across workbook tabs

Do you paste it into the same cell in each sheet?

if not you might want to use

=IF(ISERROR($O$17/$O$15),0,($O$17/$O$15))

if you want it in the same place in each sheet you can group the sheet first
and then paste it, that way you can do multiple sheets

Btw, what does "not calculate correctly" means, unexpected result?

If I copy that formula and paste it into other sheets it works fine



--
Regards,

Peo Sjoblom


"Anne Reichler" wrote in message
...
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?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy/Pasting formulas Rizing New Users to Excel 7 March 28th 07 06:38 PM
Can you copy multiple tabs from formulas to values w/o paste spec? Brent Excel Worksheet Functions 2 October 27th 05 12:47 AM
Copy tabs(sheets) from workbook without link to original source Rich Ulichny Excel Discussion (Misc queries) 3 August 25th 05 02:11 AM
Copy tabs(sheets) from workbook without link to original source Rich Ulichny Links and Linking in Excel 2 August 9th 05 03:26 PM
How to copy formulas from one workbook to another Confused Excel Discussion (Misc queries) 1 February 18th 05 06:07 PM


All times are GMT +1. The time now is 01:29 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017