Forum Discussion
Kevin_Caldewell
May 22, 2022Copper Contributor
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...
- 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
CleversonSouza
May 24, 2022Copper Contributor
hello I would like help I need the formula of a worksheet that updates the data alone but only on dashed dates
Riny_van_Eekelen
May 25, 2022Platinum Contributor
CleversonSouza Please remove your post and start a new discussion as it is not related to the thread you posted your question in.