Question

state the use of if function.explain with one example. please fast ​

Answer 1

✏It allows you to make logical comparison between a value and what you expect.

✏An IF statement can have two results:

✒The first result is, if you comparison is true.

✒ The second result is, if your comparison is false.

Example:

➡IF(A2>B2,"Over Budget","OK") = IF(A2=B2,B4-A4,"")