May 31 2020 12:43 PM
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?
May 31 2020 01:01 PM - edited May 31 2020 01:03 PM
@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.
May 31 2020 04:13 PM
SolutionJun 01 2020 01:50 PM
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:
May 31 2020 04:13 PM
Solution