Excel formulas


Microsoft Excel Fail Pass Calculation 

In Microsoft excel we use different-different formulas for different-different calculation it is most important for every user who work in excel to know all about excel formulas it is make work fast and easy to understand...

now we learn how to calculate fail pass in our excel sheet; 

create data in excel sheet as below for practice

Excel sheet









now we calculate fail pass from single subject 

Excel formuls









this is very simple to calculate fail pass in excel;see and try yourself; 
example: i want if subject number in cell b less than 33 it is show fail to student 

so we apply simple formulas for this see below 
formulas apply as =IF(B2<=33,"Fail","Pass")
And get Result as above image

Now we calculate fail pass from all subject

Excel formuls









so we apply simple formulas for this see below 
formulas apply as =IF(OR(B2<=33,C2<=33,D2<=33),"Fail","Pass")
And get Result as above image

Note: Change cell according to your data in excel sheet

this is very easy to calculate fail pass in excel sheet i hope you will understand this well and  this excel formulas info helpful for you..

Visit More