👤

Answer :

Karkalicious11go

Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it's false. For example: =IF(A2>B2,"Over Budget","OK") =IF(A2=B2,B4-A4,"")

The IF function in Microsoft Excel is the most common function in Excel that allows comparing the data.

  • The IF function can have two statements that is positive and negative.
  • Like of IF(C2='' Yes'', 1, 2). Which means of c2 is yes then return one or two.
  • Thus IF formula is used to evaluate errors.

Learn more about the correct formula for the IF function in excel.

brainly.in/question/5667072.

Go Teaching: Other Questions