Fw: [belajar-excel] Rumus IF dengan paremeter percentage

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

Fw: [belajar-excel] Rumus IF dengan paremeter percentage

Andrie -
fyi

--- On Fri, 9/28/12, Yudi Dwiyono <[hidden email]> wrote:

From: Yudi Dwiyono <[hidden email]>
Subject: [belajar-excel] Rumus IF dengan paremeter percentage
To: "[hidden email]" <[hidden email]>
Date: Friday, September 28, 2012, 8:25 AM
















 



 


   
     
     
     

Dear Master Excel,

Bagaimana /
bisakah rumus IF dengan menggunakan parameter percentage?

Dengan logika :

- Jika 0-80%
class A

- Jika 80%-90%
Class B

- Jika 90% -
100% Class CData terlampir...


Thanks.

Yudi

 



   
     

   
   






 









Percentage.xlsx (72K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Fw: [belajar-excel] Rumus IF dengan paremeter percentage

bmgnvt
This post has NOT been accepted by the mailing list yet.
bisa gunakan formula sbb:
=IF(A2<80%;"A";IF(A2<90%;"B";"C"))

dengan kondisi data pertama ada di cell A2