The IF function checks whether a condition is met and returns one value if true and another value if false.

1. For example, take a look at the IF function in cell C2 below. Explanation: if the score is greater than or equal to 60, the IF function returns Pass, else it returns Fail.

BPA Educators offers Basic and advance courses of Microsoft Excel, which helps you to keep the data of number and analyze them properly, according to the requirements and needs. Linked videos: Functions in excel- https://www.youtube.com/watch?v=R3GRg7lVycM&t=106s Popular videos: How to use a pivot table in excel https://www.youtube.com/watch?v=zuPy6zuZT2E&t=3s Data validation in excel – https://www.youtube.com/watch?v=xDVHtUYC6w8 KEY FEATURES 1 Live project A Certificate of Professional Training after the completion of course. OJT Certificate. OJT(On the Job Training). To get more updates join VIP COMMUNITY OF BPA EDUCATORS- https://www.facebook.com/groups/bpamastery/ Expert advice Call: +91-8512851249 Address: C-8/13, Sector-7, Rohini, Delhi-110085 Website: www.bpaeducators.com Instagram: https://www.instagram.com/bpaeducator/ Facebook: https://www.facebook.com/bpaeducator Twitter: https://twitter.com/EducatorsBpa LinkedIn: https://www.linkedin.com/company/bpa-educators/