Give this a try: $b$1-iv2
You are placing a dollar sign before the row and/or column reference that you want to stay static. HTH, Annette -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of D&J Murray Sent: Monday, June 07, 2010 6:58 PM To: [email protected] Subject: [Blind-Computing] Excel Formula Question I have a formula in cell B2 as follows b1-iv2 I want b1 to remain B1 when I copy it down the sheet and IV2 to progress down How do I keep b1 to remain at B1 Thanks Doug For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ __________ Information from ESET Smart Security, version of virus signature database 5180 (20100607) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 5180 (20100607) __________ The message was checked by ESET Smart Security. http://www.eset.com For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
