CAD Forum discussion (EN) : Applying formula in Excell https://www.cadforum.cz/forum_en/ Tue, 30 Jun 2026 11:30:25 +0000 Sun, 15 May 2011 19:27:11 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://www.cadforum.cz/forum_en/RSS_post_feed.asp?TID=5722 <![CDATA[CAD Forum discussion (EN)]]> https://www.cadforum.cz/forum_en/forum_images/web_wiz_forums.png https://www.cadforum.cz/forum_en/ <![CDATA[Applying formula in Excell : Thank you germanbery for sugession...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=15283&title=applying-formula-in-excell#15283 Author: aarifmahmood
Subject: 5722
Posted: 15.May.2011 at 19:27

Thank you germanbery for sugession and i have also tried my best and find solution.Actullay i wanna going to fix D4 by applying $ sign.Anyway thanks again.]]> Sun, 15 May 2011 19:27:11 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=15283&title=applying-formula-in-excell#15283 <![CDATA[Applying formula in Excell : C4=(B4-$D$4)*10+$D$4 that&#039;s...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=15267&title=applying-formula-in-excell#15267 Author: germanbarry
Subject: 5722
Posted: 13.May.2011 at 08:40

C4=(B4-$D$4)*10+$D$4
 
that's your answer. To lock the cell of one of the formula's entities, you need the dollar signs. if you put the cursor in the D4 text and press F4 key, then it will put the dollar $igns in for you automatically, fyi...
]]> Fri, 13 May 2011 08:40:03 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=15267&title=applying-formula-in-excell#15267 <![CDATA[Applying formula in Excell : OK thank u for deep intrest.I...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=14898&title=applying-formula-in-excell#14898 Author: aarifmahmood
Subject: 5722
Posted: 24.Apr.2011 at 20:52

OK thank u for deep intrest.I hve solve my problem by applying  the same formula independantly on each cell....thats all..]]> Sun, 24 Apr 2011 20:52:58 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=14898&title=applying-formula-in-excell#14898 <![CDATA[Applying formula in Excell : You can have your spreadsheet...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=14890&title=applying-formula-in-excell#14890 Author: John Connor
Subject: 5722
Posted: 23.Apr.2011 at 19:25

You can have your spreadsheet checked at any Excel Help forum.  I do not, as a habit, post my email address, except on rare occasions and usually only to review AutoCAD drawing files.  Sorry.]]> Sat, 23 Apr 2011 19:25:14 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=14890&title=applying-formula-in-excell#14890 <![CDATA[Applying formula in Excell : Thanks Mr.John Connor, ...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=14889&title=applying-formula-in-excell#14889 Author: aarifmahmood
Subject: 5722
Posted: 23.Apr.2011 at 19:04

Thanks Mr.John Connor,
             
                        I hve done my job anyway,ok I will try this on net.If you send me your mailing Id you will review it.
Thanks again.  With regards............Arif Mahmood]]> Sat, 23 Apr 2011 19:04:09 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=14889&title=applying-formula-in-excell#14889 <![CDATA[Applying formula in Excell : Do an Internet search on the following....]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=14883&title=applying-formula-in-excell#14883 Author: John Connor
Subject: 5722
Posted: 23.Apr.2011 at 13:18

Do an Internet search on the following.  Type it exactly as shown.

"excel use formula from another cell"

I think the function you are looking for is:

=GetFormula(A1)

Where (A1) is the cell the formula is located in.
]]> Sat, 23 Apr 2011 13:18:47 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=14883&title=applying-formula-in-excell#14883 <![CDATA[Applying formula in Excell : Hi, yes i consult help but realy...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=14881&title=applying-formula-in-excell#14881 Author: aarifmahmood
Subject: 5722
Posted: 23.Apr.2011 at 06:47

Hi,
  yes i consult help but realy could not follow it....
Thanks]]> Sat, 23 Apr 2011 06:47:46 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=14881&title=applying-formula-in-excell#14881 <![CDATA[Applying formula in Excell : Have you looked in Excel Help? ...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=14861&title=applying-formula-in-excell#14861 Author: John Connor
Subject: 5722
Posted: 21.Apr.2011 at 23:43

Have you looked in Excel Help?]]> Thu, 21 Apr 2011 23:43:47 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=14861&title=applying-formula-in-excell#14861 <![CDATA[Applying formula in Excell : thank u John connor.I have a sheet...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=14858&title=applying-formula-in-excell#14858 Author: aarifmahmood
Subject: 5722
Posted: 21.Apr.2011 at 20:39

thank u John connor.I have a sheet Cell A4 to a24 =Chainage,CellB4 to B24 to be input,C4 have a formula C4=(B4-D4)*10+D4,and D4=Datum level a constant.If u send your email I will send u the same file.My email is (aarifmahmood@hotmail.com)]]> Thu, 21 Apr 2011 20:39:04 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=14858&title=applying-formula-in-excell#14858 <![CDATA[Applying formula in Excell : Wouldn&#039;t you have to somehow...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=14834&title=applying-formula-in-excell#14834 Author: John Connor
Subject: 5722
Posted: 20.Apr.2011 at 12:23

Wouldn't you have to somehow reference the cell that contains the formula?]]> Wed, 20 Apr 2011 12:23:51 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722&PID=14834&title=applying-formula-in-excell#14834