Wednesday 10 February 2021

What does @ mean in an Excel formula?


 

It means “in this row only” in a structured reference.

=[@Height]*[@Width]

Means “Multiply only the contents of the cells in the columns called Height and Width that are in the same row as the cell holding this formula.”

Structured references are typically only seen in Tables but they do exist elsewhere.


(Get all types of assignment writing and essay writing service from AcademicAssignments.Co.UK)


No comments:

Post a Comment