If A1 is crates and B1 bottles

=A1+INT(B1/24)&" crates "&MOD(B1,24)&" bottles"


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=516239