Figure 1

Spreadsheet cells can contain raw data (numbers, dates, text labels and so on) or formulae. In this spreadsheet, the value in column D (Current Value) is the result of a formula: multiplying Current Shareholding by Current Share Price. The highlighted cell (D4) thus contains the formula =(B4*C4) which you can see displayed in the Data Entry box; while the result of the calculation is displayed in the cell D4 itself.

ss01.jpg (58688 bytes)