When adding a column of numbers it will keep a runniing total, but as soon as I hit the total button it rounds up to the next figure and will not give me a true total. What do I do...

If we are rounding to the nearest cent, we first locate that value. In this case, it is the second 8 to the right of the decimal. Next, we look at the number immediately to the right. In this case, it is the 4. Since this is 4 or less, we take this number and all numbers to the right to 0 and end up with 5.88.

If the 4 was a 5, the number is 5 or greater, so we have to round up by adding 1 to the cents column. In this case, it would be 5.89.

Good luck,

Paul

Your calculator is fine. It is an adding machine first, so it uses adding machine logic and you hit the star button to print the total on the tape. The equals sign is only used when multiplying and dividing.

Adding machine logic is as follows:

5+ total 5
3- total 2
7+ total 9
* print out total

Good luck,

Paul

Start with the given number 4,248.
Step 1 - identify the hundreds column - 3rd column to the left of the decimal - in this case there is a 2 in it
Step 2 - identify the column immediately to the right of this column - 2nd column to the left of the decimal - in this case there is a 4 in it
Step 3 - Whether to round up (>=5) or round down (<=4) - in this case round down - if it was 5 or more, we would round up by adding 1 to the hundreds column.
Step 4 - set the numbers to the right of the hundreds column to 0

I get 4,200.

Good luck.

Let me know if you have any questions about the steps.

Paul

To round a number, we first have to find the column in question. In this question, we need the thousands column, which has a 9 in it. Next, we go to the column immediately to the right. If the number is 4 or less, we don't add one to the thousands column and set all the numbers to the right to zero. If the number is 5 or more, we add one to the thousands column and set all the numbers to the right to zero.

In this case, the number in the column immediately to the right is a 0, so we don't have to add 1 to the thousands column, and rounded to the nearest thousand, we get 39,000.

Good luck,

Paul

Anonymous, that figures.
You want to "round up" the total, of "Bldg_Program[Floor], square # C43", Plus the "Bldg_Program[Total NSF] Times 1.05, minus 2.

Your answer will get rounded up to the next number.

Every time you enter another number, when you hit the plus button, the new number that appears is your new total. If not, try the = button

This is a very handy process when you're totaling or subtotaling columns. On the cell that you want the 'total' in type '=sum(column letter row number),(column letter row number). The first 'column letter row number' is where you want the first cell to be started in the total factor and the second 'column letter row number) is the last cell you want added in the total factor. The help (?) section is good at explaining formulas. Hope this helps, keep this process handy if you use Excel much because it'll be helpfull each time you subtotal or total columns.
Bob

Use the function =sum() to add numbers. To sum, for example, all of column A, enter in the formula bar =sum($A:$A). You can use the subtotal function within the range you are adding and the answer will not count towards the final total.

The asterix (*) next to the big fat plus key prints the running total.

Just figured that out. Why doesn't Canon have a downloadable manual for this thing?

hit *