Question

write the general Syntex of IF function​

Answer 1

IF function

In this course:

Overview of formulas in Excel

 Article

VLOOKUP

 Article

SUM function

 Article

COUNTIF function

 Article

IF function

 Article

IFS

 Article

SUMIF

 Article

SUMIFS

 Article

Automatically number rows

 Article

Calculate the difference between two dates

 Article

Define and use names in formulas

 Article

Combine text from two or more cells into one cell

 Article

Next: Tables

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(C2=”Yes”,1,2) says IF(C2 = Yes, then return a 1, otherwise return a 2).

hope this will help you

Answer 2

Explanation:

Syntax. 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 Budge,"OK")