Function Of IF In Excel

Question

What is meaning of this formula in excel? I have tried to understand but I couldn't find solution.

 IF(D12>1;1;0)

Answer 1

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.

IF(D12>1;1;0) means the following: If the value in the cell D12 is bigger than 1 then display 1 otherwise display 0.

You can get more information about each function when you click on the Insert function button in excel