Skip to main content

Determine Character from Certain Value in Ms Excel

Title of this post means : if you have a table from a list of values In Ms Excel ​​such as Test Scores, and you want to convert those values ​​to character A, B, C, D or E in other Cells  automatically without have to type it manually one by one, you can use IF Function

For example, the definition :
    Value          Using character   
0-59          E
60-74          D
75-84          C
85-94          B
95-100           A



Then the IF formula should be made in the cells that will be displayed with the Character/ letter :
(On my example below, the value is in cell C2 (column C, row 2), adjust to cell location for yours)

• For format using the separator "," (comma / Englih U.S. region format)

= IF (C2 <60, "E", IF (C2 <75, "D", IF (C2 <85, "C", IF (C2 <95, "B", IF (C2 <= 100, "A "," Error ")))))

or
• For format using separators ";" (semicolon / Malay, Indonesia..  region format)

= IF (C2 <60; "E"; IF (C2 <75; "D"; IF (C2 <85; "C"; IF (C2 <95; "B"; IF (C2 <= 100; "A ";" Error ")))))



Perform copy and paste for the next row / the next line.

Test Scores























Labels:

Popular posts from this blog

How to Enable Hyper Terminal In Windows 7

Hyperterminal Windows 7. Windows 7 Hyperterminal. Hyper terminal is used for data communication via serial port com or TCP/IP Winsock. Unfortunately on Windows 7, Windows 8 and Windows 10 we can't see anymore, even though many of us who still need it, and it is not the solution if we have to go back to Windows XP. The solution :
Read more

Vaio stuck on loading screen after upgrading to Windows 10

My Sony Vaio laptop model : VPCCA16FB with originally using Windows 7 operating system, then now I already upgraded it to Windows 10. All drivers are already installed for each device, everything is OK with this Windows 10 OS. The only problem is:  when I switch the laptop on or restarting it, after vaio logo appears then it stuck with blank screen and it takes about 2 minutes. After that, then it continues to loading Windows. After I googling about the problem, I am not only the one, other people also have the similar problem with their laptops. The cause is in the Ultra Low Power State (ULPS) system. ULPS is a feature or mode in hardware (graphics card) designed to save power by reducing energy consumption to very low levels. Now the problem is solved. If you have the same or similar problem, maybe this below step will help you too.
Post a Comment
Read more

How to deny access to a drive in Windows 10

How to disable access to drives in Windows.  One of ways to  make disable access to drives in Windows (all Windows, Windows 10, Windows 8, Windows 7, also Windows server.. ), you can use Group policy editor . Below are  the steps: 1. Press Windows + R  (to open Run command ), write gpedit.msc at Run column, then hit Enter or click OK.
Read more