If()

This helps to create logic in Excel. As we say if then that.

If(criteria,then,else)

Criteria: Is the logic that you want.

Then: If the Criteria or logic is true then want should be the value. Remember to add double inverted commas for text.

Else: If the Criteria or logic is false then want should be the value. Remember to add double inverted commas for text.