I have a problem to sum to columns. Please help....
Problem is that the first cloumn is containing the quantity of crates of
empty bottles. (24 bottles makes one crate). Second column contain the
bottles.
Third column will sum the values of two columns. If second column contain
the value of 24 then it count one crate. e.g;
Colunm1 Colunm2 Colunm3
(Crates) (Bottles) Total
55 16 ? (55 crates
& 16 bottles)
55 24 ? (Answer
will be 56)
? ? ? (Total)

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