Create, edit, or remove a calculated column in an Excel table - Support

In a Microsoft Office Excel table, you can quickly create a calculated column. A calculated column uses a single formula that adjusts for each row.

support.office.com