What do the @ symbols do in formulas

dpaton05

Well-known Member
Joined
Aug 14, 2018
Messages
1,112
What do the @ symbols do in excel formulas? The names are table column headers

Code:
=[@Rate]*([@MinHours]+[@AddHour])
What would happen if the @ symbols were not included?
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,362
Office Version
365
Platform
Windows
The @ symbols mean the formula refers to the current row of each of the columns Rate, MinHours and AddHour.
 

Forum statistics

Threads
1,082,438
Messages
5,365,531
Members
400,837
Latest member
ELMST616

Some videos you may like

This Week's Hot Topics

Top