Try
=CEILING(A1,0.5+0.5*(A1>=3))

Adding a sheet with expected results ( not just explanation) makes things easier

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

It works perfectly now. Thank you both for taking the time solving this problem for me. I will take on board your advice attaching a sheet would make it easier to understand at the other end. However I have to say you have gone beyond what some people would have done and taken the time to understand something which at the other end must have been difficult to understand.
Most people would just have had a look and said mmm move on.
Most people who are good at what they do lack the professionalism to pass their knowledge on. However you two solved that one as well thanking you both