Yes, this indeed possible — it does however require an upgrade to TablePress Pro or TablePress Max (see https://tablepress.org/pricing/) which then makes it possible to use an updated and extended version of the TablePress Single Cell Shortcode Extension, where formulas will be evaluated as well.