Hi,
I am trying to find a function in word 2003.
What I want to do is:
In my word doc i want to have a "box" or something with a already done formula. if I have a item that cost 20 kr and weighs 100 g, I would be able to put in first price then Weight in this function and then get the Price/KG.
In excel i would do something like Price/Weight*1000 = Price in KG.
But how do I get this, if itīs possible in a "Box" to Word?
Thanks!
Last edited by mostli; 10-06-2009 at 10:46 AM.
Check Word help for this:
and then use something like: =a1/b1*1000Perform calculations in a table
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Mmm...
How do I use cellīs formulas in Word?
If I have it like this:
Price Weight Price/KG
#DIV/0!
Then you just need to put in Price and Weight and you will get the price/KG.
This needs to be a "living" formula.
No problem in Excel but I canīt get it to work in Word...
Per Excel Help:
Perhaps you should consider Excel or maybe somebody can devise a VBA macro for you?Note Word inserts the result of the calculation as a field in the cell you selected. If you change the values in the referenced cells, you can update the calculation by selecting the field and then pressing F9.
Note Microsoft Word table (table: One or more rows of cells commonly used to display numbers and other items for quick reference and analysis. Items in a table are organized into rows and columns.) calculations must be manually recalculated. Consider using Microsoft Excel to perform complex calculations.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Yes probably...
Thanks for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks