Advance example of IF formula of Excel || Student grade system calculation
The Microsoft Excel IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect.
Syntax:
=IF (logical_test, [value_if_true], [value_if_false])
So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.
For example, =IF(C2=”Yes”,1,2) says IF(C2 = Yes, then return a 1, otherwise return a 2).
============================================================
Sharing is caring !!! Your responses will inspire me to upload more tutorial.💪💪
So...Share 🤝 || Like 👍 || Comment ✍️
• Our all youtube video:- https://www.youtube.com/c/mmbcampus?s...
• Excel VBA all video:- • How to use "IF, ElseIf, Else" in Excel VBA...
• Excel Formula all video:- • How to write Microsoft Excel Formula, Part...
• Ask your any question in facebook page / mmbcampus2016
• Visit https://www.mmbcampus.com to download all related file, if any.
=============================================================
Link you may need:
All pros and cons of IF formula of Excel in only 10 minutes with many examples. • All pros and cons of IF formula of Excel i...
LookUp Formula in Excel || How to get student Grade with a simple function. • LookUp Formula in Excel || How to get stud...