|You have requested that 1.5 be rounded down to 1 and also rounded up to to 2. You can't do both.|
This formula will do almost everything you asked for, except that 1.5 will always round up to 2:
If you must round 1.5 down to 1, you can combine the IF, ROUNDDOWN and ROUND functions:
For some other ways to round numbers, see this site:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.