Question

1) what is the use of If function ? Explain with an example​

Answer 1

Answer:

The 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. 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(A2>B2,"Over Budget","OK") =IF(A2=B2,B4-A4,"")