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

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

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

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..

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**

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..