Tutorial Membuat Buku Investasi Saham Sederhana Menggunakan Excel Untuk mempermudah pemahaman terhadap penjelasan di video, salin ( copy ) dan tempel ( paste ) rumus excel ( function  &  formula ) berikut pada sel yang sesuai. Sheet "Investasi", Baris 3 dan 5 Cell (J3)  =SUM(E5:E1048576) Cell (K3)  =SUM(F5:F1048576) Cell (L3)  =E3-F3 (A5)  =N(A4)+1 (C5)  =IF(E5="","",IF(E5="M",B5,IF(E5="BH",B5,IF(E5="D",B5,IF(E5="W",B5,IF(NETWORKDAYS(B5,B5+2)=3,B5+2,IF(NETWORKDAYS(B5,B5+2)=2,B5+4,B5+4))))))) (E5)  =IF(G5="","",IF(LEFT(G5,5)="Modal","M",IF(G5="Bagi Hasil","BH",IF(LEFT(G5,3)="Div","D",IF(LEFT(G5,3)="Wit","W",IF(LEFT(G5,4)="Beli","B",IF(LEFT(G5,4)="Jual","S"))))))) (F5)  =IFERROR(IFS(LEFT(G5,4)="Beli",RIGHT(G5,4),LEFT(G5,4)="Jual",RIGHT(G5,4),LEFT(G5,3)=......