| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 : How to keep =IF( ) formula at stationary position ?
Dear Sir ,
I have the formula at =IF(B2=C2,Yes,No) at A2 and copy downwards to A20. I would like the formula to be able to compare each cell at column B and C even if I move either colu7mn up and down. Currently I need to copy the formula all over again if any cell in which the formula refers to is moved. A B C 1 Ref A Ref B 2 Yes xxxx xxxx 3 Yes xxxx xxxx 4 No xxxx xxxx .. .. 20 Yes xxxx xxxx Thanks Low -- A36B58K641 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what is a formula | Excel Worksheet Functions | |||
| I was looking to get assistance with a formula in Excel 2002 | Excel Worksheet Functions | |||
| Excel 2002 Lookup formula returning wrong results? | Excel Worksheet Functions | |||
| Vlookup formula Excel version 2002 | Excel Discussion (Misc queries) | |||
| VLookup Formula Excel Version 2002 | Excel Worksheet Functions | |||
Threaded Mode
