Rownddown for sum

  • Thread starter Thread starter Diakarab
  • Start date Start date
D

Diakarab

Hello. I am trying to rounddown a sum and can't seem to figure it out. I
need the actual numbers in the cells to have decimal points, but the
total needs to be a whole number. Help : )
 
Diakarab said:
Hello. I am trying to rounddown a sum and can't seem to figure it out. I
need the actual numbers in the cells to have decimal points, but the
total needs to be a whole number. Help : )
Click to expand...

Try something like:
=ROUNDDOWN(SUM(A1:A10),0)
 
Thanks, I tried that but it ends up rounding down the total. What I nee
is for the individual amounts to round down before they are totalled
but to still appear in the cells with the decimal points. Any chance o
making that happen? Thanks again
 
Back
Top