![]() |
|
#4
|
|||
|
|||
|
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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement | Gwilson | Excel | 3 | 04-13-2017 11:31 AM |
| Help! figuring if statement with 2 vlookups excel 2013 | MWATKINS7111 | Excel | 3 | 02-24-2017 12:58 AM |
Need a little help with an if statement
|
cangelis | Excel | 2 | 04-08-2015 05:55 PM |
Mail merge will not format date field generated by Excel IF statement
|
borntorun75 | Mail Merge | 3 | 12-16-2011 06:28 AM |
Help with IF Statement
|
limpbizkit | Excel | 4 | 02-24-2011 09:16 PM |