Iya boss lupa ngasih tahu koreksinya (B1 diganti A2) saya juga pakai exel 2003
--- In [email protected], Pedhet <[EMAIL PROTECTED]> wrote: > > andri hindarta wrote: > > Contoh : > > A1 : berisi tanggal > > A2 : =WEEKDAY(A1) > > A3 : =IF(B1=1,"Mingu",IF(B1=2,"Senin",IF(B1=3,"Selasa",IF(B1=4,"Rabu", > > IF(B1=5,"Kamis",IF(B1=6,"Jumat","Sabtu")))))) > > > > Begitu ...? > > B1 itu mungkin maksudnya A2 yah ..? msh nggak bsia nih. btw saya pakai > Excel 2003 >
