10-31-2011 07:16 PM
I have a question about adding math formulas to cells. Here is an example:
I have 20 companies with 100 contact records. Each contact record has a field for how many shares of stock they own in that company. I know I can set it up so that when I change the stock price on the company record it updates each contact record with that new price. But can I also set it up so that the new stock price automatically multiplies against a field that shows how many shares they own to give me a total $ amount owned? So..."stock price field" X "shares owned field" = "total $ amount owned field". Thanks for any help you can give.