Wednesday, April 25, 2012

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

Tags

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 
• How to Combine portrait and landscape layout page in MS word 
• How to Change Measurement Unit, From Inch to Others, to mm or cm in MS Office 2007 
• How to Show Run Menu at All Programs Menu In Windows 7 
• How to Save Web Page to PDF Without Additional Software 
• 'Ghost' Picture Using your Blackberry Camera 

Artikel Terkait