Forum Discussion

Kevin_Caldewell's avatar
Kevin_Caldewell
Copper Contributor
May 22, 2022
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...
  • Riny_van_Eekelen's avatar
    May 22, 2022

    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