Programming for Everybody
حالة if المتعددة في اكسيل
نكتب الكود التالي :
=IF(M11<30,"ضعيف جدا",IF(M11<50,"ضعيف",IF(M11<65,"مقبول",IF(M11<75,"جيد",IF(M
11<85,"جيد جدا",IF(M11>=85,"ممتاز"
))))))
لاننسى نقفل الاقواس بعدد الشروط
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment