Home Blog Archive MS Office Excel: If-then-insert function

Excel: If-then-insert function

  • Oct 24, 2020
  • 125
  • 0

The If-Then function in Excel is one of the more basic functions. You can formulate this as a condition, the arrival must, to a certain rule to derive. We will tell you how to build the function.

Structure of an If-Then function in Excel

The structure of the If-Then function is relatively simple and always the same. The formula for this is: IF(condition; Then; Else). If the condition is true, then the executed statement. Is not the condition to execute the Else statement. The instructions can be arbitrarily complicated, you may not so If-Then-functions boxes.

Simple example of If-Then

On the picture you can see a simple example of the If-Then function. If the number is next to the selected field is greater than 5, it will display "Greater than 5". Otherwise, it will display "Less than 5".

YOU MAY ALSO LIKE

0 COMMENTS

LEAVE A COMMENT