• (022) 6902 1117

MENGHITUNG NILAI POSITIF

 

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.

VisualBasic Microsoft Excel

Published Budget: Rp 100,001 - 150,000
Finish Days: 1
Published Date: 25/10/2020 09:34:30 WIB
Start Date: 25/10/2020 10:46:07 WIB
Finish Date: 25/10/2020 10:51:57 WIB
Project Status: Closed
Accepted Worker: eM.Farih (eM.Farih)
Accepted Budget: Rp 100,001
Project Ending: Completed

Project Owner

agusapril

    
9.85/10.00
444 Point
#1,452 dari 1,045,196
Rated Worker: 10.00/10.00

Auto-rated by system.

Accepted Worker

eM.Farih
Kab. Gresik
    
10.00/10.00
343 Point
#1,617 dari 1,045,196
Rated Owner: 10.00/10.00

Auto-rated by system.

      User Bids

 

Recommended Workers

fauzimarjalih

14,763 points
123 projects
    
9.75/10.00

Ruly_Kompak

2,004 points
11 projects
    
9.17/10.00

appzone

4,063 points
22 projects
    
9.86/10.00

anlichandra

7,000 points
268 projects
    
9.70/10.00

viaeko

1,616 points
6 projects
    
9.00/10.00

Recommended Services

Jasa Model Machine Learning

Rp 500,000
5 sales
    
10.00/10.00

Open Projects

Aplikasi input data untuk database

Owner: nonahelps
Budget: Rp 1,000,000 - 2,000,000

Melanjutkan pembuata aplikasi purchase order

Owner: rizq123
Budget: Rp 1,500,000 - 1,500,000

Pembuatan Ladder Diagram PLC Siemens

Owner: ilham_kurniawan98
Budget: Rp 250,000 - 300,000

Koneksi IP camera CCTV ke Python

Owner: Alfanshter
Budget: Rp 300,000 - 600,000

 


Live Chat