Forum Discussion
Solved
What is the formula to divide an odd number
What is the formula to divide an odd number and enter the higher half in one cell and the lower in a different cell? For example, in golf you have a handicap and lets say it is 5, you would get 3 st...
Kevin_Caldewell Let's say the 5 handicap sits in cell A1. Then, in B1 you enter:
=INT(A1/2) to get 2,
And in C1 you enter:
=A1-B1 to get 3
Kevin_Caldewell Let's say the 5 handicap sits in cell A1. Then, in B1 you enter:
=INT(A1/2) to get 2,
And in C1 you enter:
=A1-B1 to get 3
Thank you that should work perfectly