R
Rookie
I have the following formula:=IF('LC + CC'!B3="","",'LC + CC'!B3+'LC +
CC'!B3*F69+'Sales Price (2)'!B3*'Sales Price'!F70+'Sales Price (2)'!B3*'Sales
Price'!F71+'Sales Price (2)'!B3*'Land Cost'!B14)
Im trying to copy this down multiple rows as follows:=IF('LC +
CC'!B4="","",'LC + CC'!B4+'LC + CC'!B4*F69+'Sales Price (2)'!B4*'Sales
Price'!F70+'Sales Price (2)'!B4*'Sales Price'!F71+'Sales Price (2)'!B4*'Land
Cost'!B14)
Im also trying to copy across multiple columns as follows:=IF('LC +
CC'!C3="","",'LC + CC'!C3+'LC + CC'!C3*F69+'Sales Price (2)'!C3*'Sales
Price'!F70+'Sales Price (2)'!C3*'Sales Price'!F71+'Sales Price (2)'!C3*'Land
Cost'!B14)
Each time I try it Changes all of the formula. Any help is much appreciated
CC'!B3*F69+'Sales Price (2)'!B3*'Sales Price'!F70+'Sales Price (2)'!B3*'Sales
Price'!F71+'Sales Price (2)'!B3*'Land Cost'!B14)
Im trying to copy this down multiple rows as follows:=IF('LC +
CC'!B4="","",'LC + CC'!B4+'LC + CC'!B4*F69+'Sales Price (2)'!B4*'Sales
Price'!F70+'Sales Price (2)'!B4*'Sales Price'!F71+'Sales Price (2)'!B4*'Land
Cost'!B14)
Im also trying to copy across multiple columns as follows:=IF('LC +
CC'!C3="","",'LC + CC'!C3+'LC + CC'!C3*F69+'Sales Price (2)'!C3*'Sales
Price'!F70+'Sales Price (2)'!C3*'Sales Price'!F71+'Sales Price (2)'!C3*'Land
Cost'!B14)
Each time I try it Changes all of the formula. Any help is much appreciated