Hello every one,
May be this is very simple question for every one, but i am stuck up
and can not proceed because of this simple query.
I have an Excel sheet with results. the following is final X
calculation, since i am the person who made this excel sheet so could
not undertsatnd wat exactly is happening
i am showing as in Excel sheet ( i am showing only one row but
there are more in actual one)
A B C D E F G
a1 b1 c1 d1 e1 f1 =
b1*d1*0.001*paramemeter.$b$18 - c1*1.2E-0.5
Now my dought is i have the values of b1, d1 c1 but wat exactly does
paramemeter.$b$18 means .. does it mean that we have an other folder
soem where which has the values of cell with 18 row number ..
please let me know abt this
Sing
Jason Lepack - 27 Dec 2006 13:15 GMT
$b$18 is a pointer to cell B18. The $ makes it so that when the
formula is filled down or across it will still point at B18.
Cheers,
Jason Lepack
> Hello every one,
>
[quoted text clipped - 16 lines]
>
> Sing
Suresh - 27 Dec 2006 13:34 GMT
Hello Jasan
Thanks a lot for the prompt reply. I was just woundering why is that it
is used as parameters.$b$18 and not just $b$18 does this
parameters.$b$18 had any importance ,,
suresh
> $b$18 is a pointer to cell B18. The $ makes it so that when the
> formula is filled down or across it will still point at B18.
[quoted text clipped - 22 lines]
> >
> > Sing
Suresh - 27 Dec 2006 14:49 GMT
hello
I figured it out..
Thnaks a lot
suresh
> Hello Jasan
>
[quoted text clipped - 29 lines]
> > >
> > > Sing