Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default trouble copying a formula

Oops...I thought your formula is going wrong..Check the calculation settings
under ToolsCalculation...
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Copy the cell(Ctrl+C).
Select the range you need to copy
Paste (Ctrl+V)

If this post helps click Yes
---------------
Jacob Skaria


"naj" wrote:

I have 2 collumns of data, and I want to compare them - using
=IF(F2E2,"Yes","NO"). This gives the correct answer in the cell, but when I
drag the contents down to repeat it for the rows below (by draging the
corner) the formula appears to copy correctly, showing 3's the row below,
etc, but the value provided is always the same as the first cell. Does
anyone know what I'm doing wrong

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
Trouble copying graphs galatea2153 Excel Discussion (Misc queries) 2 October 15th 07 01:58 AM
Trouble copying info into a spreadsheet Meenie Excel Worksheet Functions 9 March 20th 07 05:13 PM
TROUBLE COPYING AND PASTING FORMULAS belga Excel Worksheet Functions 2 July 3rd 06 04:03 AM
Trouble copying and pasting a formula Julie P. Excel Discussion (Misc queries) 6 March 4th 05 04:11 AM
Trouble copying and pasting a formula Julie P. Excel Worksheet Functions 4 March 3rd 05 03:16 AM


All times are GMT +1. The time now is 07:27 PM.

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

About Us

"It's about Microsoft Excel"