SOLVED

Fixing rounded answer for next formula

Copper Contributor

Hello. I am working on a spreadsheet dealing with the projected procreation numbers of animals. (I.e. I need whole numbers and not rounded numbers.) 

I have a fixed number and then a formula that calculates what the number of offspring will be at the end- this has to be a whole number so the decimal points have been removed- so far so good. My problem is that I then have a formula that adds up all the offspring in their various categories. This formula is reverting back to the underlying fraction numbers and not working solely on the rounded figures. Does anyone know how to remove this? Excel problem.png

5 Replies

@Iskrem Can you show what is in your cell of "1" of which the underlying is 0.5? I use Round function and the sum is 2 as expected.

Round.png

best response confirmed by Iskrem (Copper Contributor)
Solution
Instead of rounding the results in the column, try using the =CEILING(number,1) to use the nearest whole number upward of the result. Your total should then work. [Substitute 'number' in the formula with the whatever you use to get the number 1 currently]

Thank you so much!!! @Charla74 

You’re very welcome.

Hi@hynguyen 

 

Your reply didn't show yesterday, sorry. The matter has been solved but in case you need to know for your own peace please see below: Excel problem 2.png

1 best response

Accepted Solutions
best response confirmed by Iskrem (Copper Contributor)
Solution
Instead of rounding the results in the column, try using the =CEILING(number,1) to use the nearest whole number upward of the result. Your total should then work. [Substitute 'number' in the formula with the whatever you use to get the number 1 currently]

View solution in original post