Student Percentage:
=IF([Percentage]>=0.95,"A",IF([Percentage]>=0.88,"B",IF([Percentage]>=0.81,"C",IF([Percentage]>=0.75,"D",IF([Percentage]>=0.74,"F")))))
==================================================
columns value (Questions) based on another column (Role) selections:
If you select Developer, Question value should be 26.
=IF(Role="Architects",34,
IF(Role="Consultants",30,
IF(Role="Developers",26,
IF(Role="Engagement Managers",38,
IF(Role="Managers",28,
IF(Role="Project Managers",42,
IF(Role="Senior Sales Executives",26,0)))))))
No comments:
Post a Comment