Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

Question: truncating decimal places

My main problem is; I need to find the last figure entered in a column and use it to make calculations in other columns.


The last figure and row is changes when new figures are added so I first need to define what cell the figure is in and then use its content to make the calculations. However the software will not allow it because I am using a figure derived from a cell that came from a formula that defined it.


Have tried all sorts of ways around it even separating the 'find the cell', placing it in a redundant cell, and then using its content in the different calculation. All are prevented one way or another.

iMac, OS X El Capitan (10.11.2), 4Gb memory

Posted on

Reply

Page content loaded

Nov 11, 2017 6:05 PM in response to 2Skip2 In response to 2Skip2

Hi 2Skip2,


"However the software will not allow it because I am using a figure derived from a cell that came from a formula that defined it."


Adding to what Wayne said:


Please include the error messages you have received and the formula(s) that returned these error messages. The message may be viewed by clicking (once) on the red error triangle. With the error message displayed, you can select and copy it, then paste it into your post.


I'm guessing (one of) the error message(s) is a self-reference error—A formula cannot refer to it's own cell or to a cell whose value depends on its own cell.



Regarding finding the last entry/last row: Does the data in the target column contain any gaps (empty cells, or cells that appear empty)? Does the data in that column include ONLY numbers, or a mix of numbers and text or a mixture of numbers, text and other types of values?


Regarding the implied question in your topic line, this example shows two ways of 'truncating' a result at the second digit after the decimal:

User uploaded file

Each cell in column C shows a result of summing the values in B2 and B3. The text in column A indicates the functions used in the formula on the same row.


C2: SUM(B2:B3)

C3: TRUNC(SUM(B2:B3),2)

C4: ROUNDDOWN(SUM(B2:B3),2)


Regards,

Barry

Nov 11, 2017 6:05 PM

Reply Helpful
User profile for user: 2Skip2

Question: truncating decimal places