Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2006

Tip: Looking for answers? Try searching our database.

HELP Please -urgent

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Suresh - 27 Dec 2006 13:02 GMT
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

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.