Rounding number but not as you would expect

Originally Posted by ChemistB

=IF(AND(MOD(A1,1)<=0.594,MOD(A1,1)>=0.01), INT(A1)+ 0.5, ROUND(A1,0))
For the second part, we need to expand the formula futher
=IF(INT(A1)<1, 1, IF(AND(MOD(A1,1)<=0.594,MOD(A1,1)>=0.01), INT(A1)+ 0.5, ROUND(A1,0)))

Would that work for you?

Works a dream with one exception. If a1 is left blank it returns a 1 for numbers of pallets required as opposed to blank or 0.

Any ideas on that one. Thank you so much so far. Never would have got this.