How do I get numbers to foot across rows and colums?

K

k

How do I get numbers to foot across rows and colums? The numbers foot
correctly in the spreadsheet, but do not when added manually on a report.
 
D

Duke Carey

Two choices:

1) add a footnote that numbers may not foot due to rounding
2) round the individual numbers to the precision displayed.

If you choose #2 and you're displaying 1 decimal place, use

=ROUND(cell reference/formula/value goes here,1)

for each entry in your column/row
 

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

TEENSY diy easy build foot switches for gamers 1
Picking up last value in column in Excel 3
Sum Days into Weeks 1
Preorder GFX card? 8
Asterix, how to replace it? 2
How do I set up sub-headings in Excel? 1
Page Layout 1
sum of cells in different rows & columns & criteria 6

Top