truncating decimal places

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:

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

please post a screenshot of the table in question with made up date if possible. truncating decimal places seems different than the description of the problem