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!

Hi,

=c6*root!$g$3

C6 is a cell in the worksheet the formula is in

$G$3 is cell G3 on a worksheet called Root

the formula multiplies these 2 cells together

The dollar signs stop G3 changing if the formula is dragged down or across
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"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!

"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!

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!

.

You're welcome - thanks for feeding back.

Pete

On Apr 15, 3:02*pm, Prashant
wrote:
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!

.- Hide quoted text -

- Show quoted text -