Absolute values and rounding down

Morning all...

I have an issue with absolute values... could someone advise if there is a way I can have an initial value in a cell that is 2 decimal points and I need to add a conditional format to the cell that will provide an absolute value to the cell and always round the decimal down. IE 2.59 = absolute value 2

Now that probably seems crystal to some folk... but I can't for the life of me work out the formula to do this.

I'm not sure if this would do what you want, and you probably already thought of this, but would inserting a column help?

Let's say 2.59 was in column B (cell B1)
In column C (Cell C1) you could type: =ABS(ROUNDDOWN(B1,0))
By hiding column B, the value in column B would still be there for future calculations but it would always show up in column C as a positive integer. You can do calculations on either column as appropriate and you could then add other conditional formats to column C as required.

Like I said, you probably already thought of that so I'm sorry if this doesn't help.

It's an interesting question that has me intrigued, too, because--like you probably, the formula reworked into conditional formatting didn't work in a few ways I quickly tried either.

I'll be curious about other strategies.

Ok now that works.... but only on the total value of the cell that has the final value.... taking that one step further how do I incorporate that into a cell that is pulling a sales figure from a previous worksheet.....

For example Sales sheet one has the months sales figures for a client and I am pulling information with the following: =('Total per Month 07'!L2)

Now that pulls a value of xyz.xx into the sales sheet 2... follow??? :-) Every month I have a column that represents the sales figures for a client for that month... I then have a column that totals the month figures.

I want to add to the initial formula for pulling the month sales figures into sales sheet 2 [=('Total per Month 07'!L2)] a round down that will round the value of the calculated cell without adding a column on every month... and then a final total with no decimal places at year end total... now this really is probably as clear as mud... Please see attachment if it helps :-)