MS Works Database - using a formula to calculate cells

[Guest]

About MS Works Database - using a formula to calculate cells

This is probably simple if you know it already.
My field 1 is called x, and contains numbers, say 1,2,3,4 etc
my field 2 is called y, and contains different numbers, 10,20,30,40 etc

I would like to have field 3, which I call xy, created by the application of
a formula, but could not find anything in the list of functions and
parameters that says or does PRODUCT.
I tried 'x' x 'y' and 'x' times 'y' and other variations without luck.
Feel sure there will be something that does this job especially since 'x'^2
worked, and SUM SQRT LOG and more complicated functions are here. Can you
help ?

Also I would like to know how to make the sum of items in a column, (ie
FIELD), APPEAR UNDER that column using another formula. Many thanks

Please post reply here

 

[Carey Frisch [MVP]]

Please visit the Works experts in the Works newsgroup:
news://msnews.microsoft.com/microsoft.public.works.win

--
Carey Frisch
Microsoft MVP
Windows XP - Shell/User

Be Smart! Protect Your PC!
http://www.microsoft.com/athome/security/protect/default.aspx

---------------------------------------------------------------------------

:

| About MS Works Database - using a formula to calculate cells
|
| This is probably simple if you know it already.
| My field 1 is called x, and contains numbers, say 1,2,3,4 etc
| my field 2 is called y, and contains different numbers, 10,20,30,40 etc
|
| I would like to have field 3, which I call xy, created by the application of
| a formula, but could not find anything in the list of functions and
| parameters that says or does PRODUCT.
| I tried 'x' x 'y' and 'x' times 'y' and other variations without luck.
| Feel sure there will be something that does this job especially since 'x'^2
| worked, and SUM SQRT LOG and more complicated functions are here. Can you
| help ?
|
| Also I would like to know how to make the sum of items in a column, (ie
| FIELD), APPEAR UNDER that column using another formula. Many thanks
|
| Please post reply here
| --
| Ian Hutcheson