It would require VBA. When would you want it displayed? If you
recalculate? Which cells would you want displayed? Would you want the
formula displayed when you select the cell?

Lots of questions before you get what you want.

This *may* be a start. Right click on the sheet with the formula and
select VIEW SOURCE and paste this in. If you select the cell, you'll get the
equation in the cell. It doesn't give the values that make it up. THat
would require a good bit more code, I suspect.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count 1 Then Exit Sub

Application.StatusBar = Target.Formula & "=" & Target.Value

End Sub

HTH,
Barb Reinhardt

"oldLearner57" wrote:

hi community

can community assist me on this matter...

when i do a sum or average on cell range, and is it possible to have the
function example, =sum(value+value) display on the excel status bar (the
bottome area of the excel interface)
and if possible,
can the display be adjusted


thanks community for the help


:)
--
oldLearner57