Skip to main content

Pass or Fail From The Value in Ms Excel ( simple IF function)

If you want to make an automatic remark or result from one value in Ms Excel, you can use IF Function.
For example :  If the value = 70 or above the result is PASS
If the value below 70 the result is FAIL
To make the word PASS or FAIL without typing them, use the simple IF function bellow

In the example below, column A is used for value, and column B to indicate the PASS or FAIL from the value,
To make automatic PASS or FAIL without typing them, In the column B use this formula :



=IF(A1>=70,"PASS","FAIL")



Copy and paste for the next rows.


See Also :
• How to Protect Ms Excel File using Password 
• How to Determine Character from Certain Value in Ms Excel 
• How to Resolve the problem : Couldn't Open CSV file Correctly in Ms Excel 
• How To Resize Picture (reduce file size) Using MS Outlook 

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