locking formula

  • Thread starter Thread starter puronombre
  • Start date Start date
P

puronombre

I have a column with this formula for a columd of data: IF
($I164>$J164,2,0) and I need to insert a column between H
and I so the formula changes to compare columns J and k
and not I and J.

My question is probably very simple to answer but I do not
know how to keep the formula to compare columns I and J
all the time even if I include new columns.
 
Great!!!

Thank you very much Ken

-----Original Message-----
=IF(INDIRECT("$I164")>INDIRECT("$J164"),2,0)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

---------------------------------------------------------- ------------------
Attitude - A little thing that makes a BIG difference
---------------------------------------------------------- ------------------






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.522 / Virus Database: 320 - Release Date: 29/09/2003


.
Click to expand...
 
Back
Top