![]() |
#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 |
Thread Tools | |
Display Modes | |
|
![]() |
||||
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 |
![]() |
cangelis | Excel | 2 | 04-08-2015 05:55 PM |
![]() |
borntorun75 | Mail Merge | 3 | 12-16-2011 06:28 AM |
![]() |
limpbizkit | Excel | 4 | 02-24-2011 09:16 PM |