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 ca...
- 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]
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]
