With the shape selected, click into the formula bar, type '=', enter the
required formula and press enter.

"A" wrote:

How do i add a formula to a shape in excel?