DICARI yg bisa membuat fungsi if+sum sbb:
Date | NET BUY SELL ASING HARIAN | HASIL | |
12/28/2009 | -9,975,350,272 | 0 | |
12/29/2009 | -15,155,919,872 | 0 | |
12/30/2009 | 1,698,300,032 | 1 | |
1/4/2010 | 28,214,159,360 | 2 | |
1/5/2010 | 50,619,154,432 | 3 | |
1/6/2010 | 38,314,450,944 | 4 | |
1/7/2010 | 26,244,855,808 | 5 | |
1/8/2010 | -19,289,270,272 | 6 | |
1/11/2010 | 24,820,180,992 | 7 | |
1/12/2010 | 132,508,000,256 | 8 | |
1/13/2010 | 12,271,904,768 | 9 | |
1/14/2010 | 15,227,429,888 | 10 | |
1/18/2010 | 73,793,896,448 | 11 |
Jika kolom NET BUY SELL ASING HARIAN minus maka 0, namun jika hari berikutnya nilai positif terhitung 1 dan hari berikutnya msh positif aka 2 dst..jika sudah total minus maka 0 dan akan menjadi 1 jika ada net buy sell asing positif lagi..
Maksimalkan dengan rumus excel saja (bukan VBA)
data terlampir.