[Advanced Excel] Creating excel Formula

[Advanced Excel] Creating excel Formula

  
Forge Component
(36)
Published on 9 Apr by Hanno
36 votes
Published on 9 Apr by Hanno
I have just started experimenting with the advanced Excel tools and wondered if any one knows how to create a cell containing a formula.
For example I would simply like to add a total at the end of a table that is dynamic.

"=SUM(A1:A10)"

Cheers

Steve