I posted the message below in the ...excel.misc newsgroup, but think
maybe it would be more appropriately posted here;

----------------------------------------------------
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

Please don't post in multiple news groups

Tyro

"Charliec" wrote in message
...
I posted the message below in the ...excel.misc newsgroup, but think
maybe it would be more appropriately posted here;

----------------------------------------------------
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

Charlie:

Try =rounddown((220-F2)*0.9,0)

You don't need the sum as it is only a subtraction of a single cell.

Hope this helps
Martin Fishlock, www.nyfconsultants.com, Bangkok, Thailand
Please do not forget to rate this reply.


"Charliec" wrote:

I posted the message below in the ...excel.misc newsgroup, but think
maybe it would be more appropriately posted here;

----------------------------------------------------
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