View a formula and its result at the same time
MS OFfice Web Components Spreadsheet
View a formula and its result at the same time
- In the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.
- Click the cell that contains the formula you want to view.
- On the toolbar, click Commands and Options
,
and then
click the Formula tab.
- Review the formula in the Formula in active cell (reference)
box. The result of the formula is displayed
in the Cell value box.