Microsoft should make the Relative and Absolute subroutines standard. I have
to generate sheets using a mix of absolute and relative references all the
time, only to have to turn around and wish that they were all relative so I
can have their functions apply to other data.
This is a heck of a useful thread.
"lostinformulas" wrote:
I have a long formula that I have applied in multiple cell once it is in
the cell I need this formula to be absolute.
Is there an easy way or do i have to go into each cell and add the $??
=IF(AND('1'!$A70="yes",'1'!$AP70="yes",'1'!$AT70=" Express",'1'!$D70="yes"),0.5,IF(AND('1'!$A70="yes" ,'1'!$AP70="yes",'1'!$AT70="express"),1,""))
--
lostinformulas
------------------------------------------------------------------------
lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229
View this thread: http://www.excelforum.com/showthread...hreadid=551116