Excel 2007 - RoundDown in Calculation?

C

Charliec

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
 
R

Rhiannon McKay

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
 
C

Charliec

Got it, worked like a charm.
Thanks a lot!
Charlie
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
Click to expand...
******************************************************
Charliec
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 - Rounddown Function? 2
ROUNDING DOWN 4
How to count the numbers in a Word document? 0
Using ROUNDDOWN - Help please 3
Calculation Time 2
ROUNDDOWN 3
Rounding IF statement? 6
Rounding down with a calculation 3

Top