How to set If condition in the Ms excel

MS excel provide us different defined functions like Sum If average etc under formula tab in function button

first we fill the up data as we required now here I am using student subject result and calculate different subjects result percentage and after calculating the percentage value apply the If condition on it to decide the result (Pass Or Fail)

1. Click on formula Tab
2. Click on insert function

after clicking on the insert function new window show

click on the IF as picture shown and click on Ok button new window will appears like below window shown

Here is the Logical_test we put value D2>=45 means that percentage value of English subject is greater or equal to 45 it place E2 Pass else Fail. 45 is our defined range which decide the Fail or Pass.

Next field is value if true we put Pass and next field value if false we put Fail 

if logical test goes to true then the value if true place on E2 else value if false on E2 

using the auto fill data click on spot and drag down to 6 row

In this Post we learnt about IF function and how apply on the data