Change calculations to use column names

Hi,

I have a table where caluclations appear like this: =IF(O18="","",IF(O18=0,"X",IF(O18>0,"W",IF(O18<0,"L"))))

Is there a button I can click to make all these table calculations rather use the names of the appropriate columns, for example, column O is called [@[Gross P&L]]

I know I could manually go and change this, but my table has mean columns with calculations.

Thanks,
Michelle

Originally Posted by FDibbins

If that is a structured table, and those references are inside the table, they should show that way anyway?

No, they don't. Although I can manually succesfully change them. I just want to avoid doing this as it is prone to error

Does anyone know how to do this automatically, I'm sure I remember seeing the option somewhere...

Here's an article on using STRUCTURED REFERENCES:
https://support.office.com/en-us/art...3-c8ae6d2b276e

Hope this helps!