How can I subtract 2 columns in a table?

B

Becky

I am trying to subtract figures from 2 different cells of a table and can
not get a SUB formula to work?
 
A

Andrea Jones

Use Table->Formula to start your formula and then work out the 'cell
references' in the table by labelling the columns A, B, C and the rows 1, 2,
3 as you would in Excel, you can then write a formula like A1-B1 in the
formula box and this will do your calculation.

Andrea Jones
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List all tables, including document structure 0
I'm sure its an easy answer.... 1
Excel - Wich Function should I use? 1
Need Help with a VBA subroutine 0
Append Crosstab Query to Existing Table 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to implement subtraction from a range 1
Consolidation Table from Different Excel Tabs with Different Format 1

Top