CAD discussion forum - ask any CAD-related questions here, share your CAD knowledge on AutoCAD, Inventor, Revit and other Autodesk software with your peers from all over the world. To start a new topic, choose an appropriate forum.
Please abide by the
rules of this forum.
This is a peer-to-peer forum. The forum doesn't replace the official direct technical support provided by ARKANCE for its customers.
How to post questions: register or login, go to the specific forum and click the NEW TOPIC button.
| Author |
 Topic Search  Topic Options
|
aarifmahmood 
Newbie
Joined: 05.Apr.2011
Location: Pakistan
Using: Autocad 2006
Status: Offline
Points: 13
|
 Topic: Applying formula in Excell
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
|
 |
John Connor
Senior Member
Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2018
Status: Offline
Points: 7175
|
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>>
|
|
aarifmahmood
Newbie
Joined: 05.Apr.2011
Location: Pakistan
Using: Autocad 2006
Status: Offline
Points: 13
|
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
|
|
John Connor
Senior Member
Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2018
Status: Offline
Points: 7175
|
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>>
|
|
aarifmahmood
Newbie
Joined: 05.Apr.2011
Location: Pakistan
Using: Autocad 2006
Status: Offline
Points: 13
|
Posted: 23.Apr.2011 at 06:47 |
Hi,
yes i consult help but realy could not follow it....
Thanks
|
|
Arif Pakistan
|
|
John Connor
Senior Member
Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2018
Status: Offline
Points: 7175
|
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>>
|
|
aarifmahmood
Newbie
Joined: 05.Apr.2011
Location: Pakistan
Using: Autocad 2006
Status: Offline
Points: 13
|
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
|
|
John Connor
Senior Member
Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2018
Status: Offline
Points: 7175
|
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>>
|
|
aarifmahmood
Newbie
Joined: 05.Apr.2011
Location: Pakistan
Using: Autocad 2006
Status: Offline
Points: 13
|
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
|
|
germanbarry
Groupie
Joined: 14.Apr.2011
Location: Germany
Using: AutoCAD 2011
Status: Offline
Points: 33
|
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...
|
|
![CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]](/common/arkance_186.png "CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]")
Discussion forum
Applying formula in Excell
Tweet
