Formulae with word lookups and numeral calculations to word...

[Dan1000]

I have a series of formulae which looks up words and calculates some figures in Excel which works.

Is it possible to improve on it by setting it up in Word where I need the finished product so people do not have to go to Excel each time - I got to a stage of embedding an excel table in Word but fail to know whether you can make the formula work there whilst not having Excel open or maybe export the formula somehow to Word - although I feel at least the latter would not be compatable?!

If not, is there a best practice way of transferring the data to Word to retain all the formatting and formula answers?

Any help is much appreciated!

 

[Yongle]

I have a series of formulae which looks up words and calculates some figures in Excel which works ...
Is it possible to set it up in Word ... so people do not have to go to Excel each time ?

What EXACTLY are you wanting Word to be able to do that is currently being done in Excel ?

 

[Dan1000]

Work out the formulae and not have to go to Excel every time I need the end product in Word,
Keep all the formatting, which I otherwise am having to adjust each time when I copy and paste a table from excel to word.

 

[Macropod]

Word has no lookup functions of any kind. That said, to see how to do a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial, available at:
Microsoft Word Field Maths Tutorial
or:
Graham Mayor - Downloads

 

[Dan1000]

Thank you. I understand word not having lookups as they are quite complex. Perhaps it will accept an if then type function as this may be a way around?!

 

[Macropod]

Yes, much can be done with IF tests. Read the tutorial.