 SOLVED

Highlighted

# Fixing rounded answer for next formula

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? 5 Replies
Highlighted

# Re: Fixing rounded answer for next formula

@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. Highlighted
Best Response confirmed by Iskrem (New Contributor)
Solution

# Re: Fixing rounded answer for next formula

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

# Re: Fixing rounded answer for next formula

Thank you so much!!! @Charla74

Highlighted

# Re: Fixing rounded answer for next formula

You’re very welcome.
Highlighted

# Re: Fixing rounded answer for next formula

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: 