Forum Discussion
Solved
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?
- 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]
5 Replies
- 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]
