Thank you Mike and Peter for the solution. Appreciate it.

"Pete_UK" wrote:

"root" is the name of a sheet in the file - it may have been hidden.
The formula basically multiplies the contents of cell C6 with G3 in
the root sheet.

Hope this helps.

Pete

On Apr 14, 4:07 pm, Prashant
wrote:
I had this file with me. there were few hiddne formula. i found out one
formula which was =c6*root!$g$3. My Question is whats is the use of this
formula and how it works. Also, why im unable to find it in excel help tool?

Thanks in advance for help!

.