#computer #computerclass #compitition #computercourse #competitive #exams #
What is function in MS Excel with example?
Functions are predefined formulas in Excel. They eliminate laborious manual entry of formulas while giving them human-friendly names.
How do you write if and if in Excel?
Image result for if function in excel
When you combine each one of them with an IF statement, they read like this:
AND – =IF(AND(Something is True, Something else is True), Value if True, Value if False)
OR – =IF(OR(Something is True, Something else is True), Value if True, Value if False)
NOT – =IF(NOT(Something is True), Value if True, Value if False)
