ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I get numbers to foot across rows and colums? (https://www.excelbanter.com/excel-worksheet-functions/229157-how-do-i-get-numbers-foot-across-rows-colums.html)

K

How do I get numbers to foot across rows and colums?
 
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.

Duke Carey

How do I get numbers to foot across rows and colums?
 
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

"k" wrote:

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.



All times are GMT +1. The time now is 09:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com