Pake rumus ini... mungkin manjur....

=IF(AND(N16>27,N16<=35),"buy",IF(AND(N16>18,N16<=27),"hold","sell"))

thx




________________________________
From: empu <[email protected]>
To: XL mania <[email protected]>
Sent: Thursday, July 16, 2009 2:43:38
Subject: ]] XL-mania [[ apa yg salah dengan formula ini

  
Dear Friend,
Saya coba membuat formula sederhana. Bila dilihat formula di O16 & O20 
maksudnya adalah sama, tapi bisa memberikan hasil yg beda. TRus kalau angka di 
N16 & N20 dirubah2, result tetep sama. Jd salahnya dimana ya. Mohon pencerahan.
Ade 

   


      New Email addresses available on Yahoo!
Get the Email name you&#39;ve always wanted on the new @ymail and @rocketmail. 
Hurry before someone else does!
http://mail.promotions.yahoo.com/newdomains/aa/

Kirim email ke