This video shows how to assign a formula or function to a cell with a VBA Macro.

Handy Excel Resources
https://amzn.to/3gFx7s1 Excel Formulas & Functions For Dummies 5th Edition
https://amzn.to/3sYnuH6 Microsoft Excel 2019 VBA and Macros
https://amzn.to/2PqXhU0 MICROSOFT EXCEL VBA AND MACROS FOR BEGINNERS:
https://amzn.to/3xtsLtM Microsoft Excel VBA Programming for the Absolute Beginner
https://amzn.to/3xwkEg0 Excel 2019 Bible
https://amzn.to/3aJEHxW EXCEL 2020 FOR BEGINNERS

As an Amazon Associate, I earn from qualifying purchases. Product prices and availability are subject to change.