There are various types of these statements you can use depending on the criteria for testing a condition, as well as when you want the test to be conducted. Here's a quick overview of some of them and their syntax:
=IF(A1="Yes", "Hello World","Hello Universe") - evaluates A1 for "yes" and displays "hello world" if it does so
=IF(A1="No", "<math>FINAL VALUE</math>","<math>SUPER DUP
To learn how to make an IF statement and to download the resource, please visit:
Excel IF Function – How to Use