[belajar-excel] Fwd: MODERATE -- pmaho_ss9@pinusmerahabadi.co.id posted to belajar-excel [1 Attachment]

classic Classic list List threaded Threaded
2 messages Options
Kid
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Fwd: MODERATE -- pmaho_ss9@pinusmerahabadi.co.id posted to belajar-excel [1 Attachment]

Kid
Administrator
---------- Forwarded message ---------
From: Yahoo Groups Notification <
[hidden email]>
Date: Thu, Dec 19, 2019 at 9:47 AM
Subject: MODERATE -- [hidden email] posted to belajar-excel
To: <[hidden email]>



Hello,

A message has been sent to the belajar-excel group from

  [hidden email]

The message summary:
--------------------
FROM: [hidden email]
DATE: Thu, 19 Dec 2019 08:30:08 +0700
SUBJECT: Hitung

Dear All,

Assalamu'alaikum Wr Wb..

Mohon bantuannya untuk formula cell warna hijau.

Wassalamu'alaikum Wr Wb..

DD

--------------------



---------- Forwarded message ----------
From: Dede Sulaeman <[hidden email]>
To: <[hidden email]>
Cc:
Bcc:
Date: Thu, 19 Dec 2019 08:30:08 +0700
Subject: Hitung

Dear All,



Assalamu’alaikum Wr Wb..



Mohon bantuannya untuk formula cell warna hijau.



Wassalamu’alaikum Wr Wb..





DD

Hitung.xlsx (15K) Download Attachment
Kid
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Re: MODERATE -- pmaho_ss9@pinusmerahabadi.co.id posted to belajar-excel

Kid
Administrator
Begini :
*D1:O1* diisi angka berurutan dari 1 sampai 12

> ytd :
=*SUM*IFS(D4:O4,*$D$1:$O$1*,"<="&MATCH(*$D$10*,$D$3:$O$3,0))

> average lebih dari nol
=*AVERAGE*IFS(D4:O4,*$D$1:$O$1*,"<="&MATCH(*$D$27*,$D$3:$O$3,0)*,D4:O4,">0"*
)
*** yang di-*bold* adalah perbedaannya

> yang terakhir
>> bulan =LOOKUP(2,1/D4:O4,*$D$3:$O$3*)
>> nilai =LOOKUP(2,1/D4:O4,*D4:O4*)
  *** yang di-*bold* adalah perbedaannya



On Thu, Jan 9, 2020 at 12:04 AM Mr. Kid <[hidden email]> wrote:

>
>
> ---------- Forwarded message ---------
> From: Yahoo Groups Notification <
> [hidden email]>
> Date: Thu, Dec 19, 2019 at 9:47 AM
> Subject: MODERATE -- [hidden email] posted to
> belajar-excel
> To: <[hidden email]>
>
>
>
> Hello,
>
> A message has been sent to the belajar-excel group from
>
>   [hidden email]
>
> The message summary:
> --------------------
> FROM: [hidden email]
> DATE: Thu, 19 Dec 2019 08:30:08 +0700
> SUBJECT: Hitung
>
> Dear All,
>
> Assalamu'alaikum Wr Wb..
>
> Mohon bantuannya untuk formula cell warna hijau.
>
> Wassalamu'alaikum Wr Wb..
>
> DD
>
> --------------------
>
>
>
> ---------- Forwarded message ----------
> From: Dede Sulaeman <[hidden email]>
> To: <[hidden email]>
> Cc:
> Bcc:
> Date: Thu, 19 Dec 2019 08:30:08 +0700
> Subject: Hitung
>
> Dear All,
>
>
>
> Assalamu’alaikum Wr Wb..
>
>
>
> Mohon bantuannya untuk formula cell warna hijau.
>
>
>
> Wassalamu’alaikum Wr Wb..
>
>
>
>
>
> DD
>
>
>
>
>
>
>