Coba formula : =IF(COUNTA(DTB!A2:O2)=15,SUBSTITUTE(TEXT(SUMPRODUCT(DTB!A2:H2*10^(8-COLUMN(DTB!A2:H2))),"00,000,000")&"."&TEXT(SUMPRODUCT(DTB!I2:O2*10^(7-COLUMN(DTB!A2:G2))),"0,000,000"),",","."),REPT(0=1,COUNTA(DTB!A2:O2)>0))
Wassalam, Kid. On Thu, Mar 15, 2012 at 20:37, Wewith Isme <wewithi...@ymail.com> wrote: > ** > > > bagaimanakah agar berfungsi juga pada excel 2007 keatas? > > > >
