|
| 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
April 14th, 2010, 04:07 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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
April 14th, 2010, 04:13 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
April 14th, 2010, 04:15 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
April 15th, 2010, 03:02 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
April 16th, 2010, 01:49 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | |
|
|
Linear Mode
