Split the numbers in excel in whole numbers, if the number is even split in 2 equal halves and if odd give higher half to the 1st and rest to 2nd

[Gyanendra]

Column A is the total score , Split the numbers in excel in whole numbers, if the number is even split in 2 equal halves and if odd give higher half to the 1st and rest to 2nd

 

[Fluff]

How about
In B2

=ROUNDUP(A2/2,0)

and in C2

=INT(A2/2)

 

[Gyanendra]

Hi
Thank you so much for the quick response. it works as required.
Thanks a lot

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Scott Huish]

Another possibility:
in B2: =-INT(-A2/2)
in C2: =A2-B2