Tuesday, June 2, 2020

Absolute reference?

Wilbur Marksberry: =A1.Sometimes you'd also have to specify the sheet.=Sheet1!A1That's =[SHEETNAME] ! [CELL}== EDIT - Above is RELATIVE - ==Absolute:In a formula, the exact address of a cell, regardless of the position of the cell that contains the formula. An absolute cell reference takes the form $A$1.)...Show more

No comments:

Post a Comment