If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need help with below question
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! |
#2
|
|||
|
|||
Need help with below question
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! |
#3
|
|||
|
|||
Need help with below question
"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! |
#4
|
|||
|
|||
Need help with below question
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! . |
#5
|
|||
|
|||
Need help with below question
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 - |
Thread Tools | |
Display Modes | |
|
|