| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
trouble copying a formula
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
trouble copying a formula
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
trouble copying a formula
First thing to try is:
Tools Options Calculation and check Automatic -- Gary''s Student - gsnu200855 "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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
trouble copying a formula
1. maybe all the results are right
2. maybe you need to change your calculation settings from Manual to Automatic Tools-Options-Calcualtion tab-set to Automatic On 27 Maj, 12:39, 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trouble copying graphs | Excel Discussion (Misc queries) | |||
| Trouble copying info into a spreadsheet | Excel Worksheet Functions | |||
| TROUBLE COPYING AND PASTING FORMULAS | Excel Worksheet Functions | |||
| Trouble copying and pasting a formula | Excel Discussion (Misc queries) | |||
| Trouble copying and pasting a formula | Excel Worksheet Functions | |||
Linear Mode
