Applying formula in Excell
Printed From: CAD Forum
Category: EN
Forum Name: CAD - general
Forum Description: General discussion about CAD, formats, standards, management, licensing, networking, harware, other CAD applications
URL: https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5722
Printed Date: 30.Jun.2026 at 09:43
Topic: Applying formula in Excell
Posted By: aarifmahmood
Subject: Applying formula in Excell
Date Posted: 19.Apr.2011 at 20:15
|
Hello everyone here,
I hve an excell sheet and apply a formula.Although I solve it by putting that formula in every cell but the basic formula is same only only one cell is changeable.If someone like to tell me that how could
it be work if put once in the sheet it will not be repeat again and again.........thanks.....I can send the file if someone like it..  ------------- Arif Pakistan |
Replies:
Posted By: John Connor
Date Posted: 20.Apr.2011 at 12:23
|
Wouldn't you have to somehow reference the cell that contains the formula? ------------- "Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance." <<AutoCAD 2015>> |
Posted By: aarifmahmood
Date 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)
------------- Arif Pakistan |
Posted By: John Connor
Date Posted: 21.Apr.2011 at 23:43
|
Have you looked in Excel Help?
------------- "Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance." <<AutoCAD 2015>> |
Posted By: aarifmahmood
Date Posted: 23.Apr.2011 at 06:47
|
Hi,
yes i consult help but realy could not follow it....
Thanks ------------- Arif Pakistan |
Posted By: John Connor
Date 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. ------------- "Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance." <<AutoCAD 2015>> |
Posted By: aarifmahmood
Date 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 ------------- Arif Pakistan |
Posted By: John Connor
Date 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.
------------- "Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance." <<AutoCAD 2015>> |
Posted By: aarifmahmood
Date 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.. ------------- Arif Pakistan |
Posted By: germanbarry
Date 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...
|
Posted By: aarifmahmood
Date 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. ------------- Arif Pakistan |