What's new
Symbianize Forum

Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.

All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!

Excel IF function help po.

D

danger_zone16

Novice
Advanced Member
Messages
47
Reaction score
2
Points
28
Guys paano ba i-shorten ang formula na to?
Meron bang ibang pwedeng gamitin na formula? Grade transmutation ko to. Haba kasi ng IF statement eh.

=IF(D4>=74;87;IF(D4>=72;86;IF(D4>=70;85;IF(D4>=68;84;IF(D4>=66;83;IF(D4>=64;82;IF(D4>=62;81;IF(D4>=60;80;IF(D4>=58;79;IF(D4>=56;78;IF(D4>=54;77;IF(D4>=52;76;IF(D4>=49.5;75;IF(D4>=47.5;74;IF(D4>=45.5;73;"F")))))))))))))))

Thanks.
 
mas maganda TS kung nakikita yung excel file mas madali para kita ang galaw ng formula :)
 
You must log in or register to reply here.
Back
Top Bottom