Wednesday, April 25, 2012

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