Excel 2007 - RoundDown in Calculation?
 

I have a calculation setup in a column with no decimal points (whole
numbers only). The calculation results in the number being rounded
up. I would like the number to be round down to the whole digit
number (ie if the result is 23.78, I would like it round down to 23).
Below is a example of the current formula:

=SUM((220-F2)*0.9)

What do I have to add to this calculation to get it to round down.

Thanks
Charlie
************************************************** ****
Charliec

Excel 2007 - RoundDown in Calculation?
 

Change the formula to:

=ROUNDDOWN(SUM((220-F2)*0.9),0)

and that will round it down to a whole number (i.e. 0 decimal places)

Rhiannon

Excel 2007 - RoundDown in Calculation?
 

Look at the functions INT, ROUNDDOWN and TRUNC to see which suits your
needs.
Your formula does not need SUM as this will work =(220-F2)*0.9

Tyro

"Charliec" wrote in message
...
I have a calculation setup in a column with no decimal points (whole
numbers only). The calculation results in the number being rounded
up. I would like the number to be round down to the whole digit
number (ie if the result is 23.78, I would like it round down to 23).
Below is a example of the current formula:

=SUM((220-F2)*0.9)

What do I have to add to this calculation to get it to round down.

Thanks
Charlie
************************************************** ****
Charliec

Excel 2007 - RoundDown in Calculation?
 

Got it, worked like a charm.
Thanks a lot!
Charlie

On Thu, 10 Apr 2008 21:07:01 -0700, Rhiannon McKay wrote:

Change the formula to:

=ROUNDDOWN(SUM((220-F2)*0.9),0)

and that will round it down to a whole number (i.e. 0 decimal places)

Rhiannon
************************************************** ****
Charliec

Excel 2007 - RoundDown in Calculation?
 

"Charliec" wrote:

Got it, worked like a charm.
Thanks a lot!
Charlie


Glad to be of help!

Rhiannon