|
|
#2
07-27-2015, 01:41 PM
|
|||
|
|||
Nope. IIF is an Access function. IF is the Excel Function. Other than that:
* the parentheses around b2="XYZ" are superfluous * there is no ELSE option in the formula * the ," at the end will cause an error * the whole thing looks like a kludge No idea what you are trying to accomplish. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 formula, 2 criteria, one result
|
cjdstephenson | Excel | 4 | 06-02-2015 09:17 PM |
|
Show result of formula as a value in another cell
|
Steve_D | Excel | 4 | 10-12-2014 07:38 PM |
| Convert Formula Result to Static Text | MYGS | Excel | 16 | 01-21-2013 08:18 AM |
| IF formula returns wrong result | mashley | Excel | 3 | 09-07-2012 07:03 AM |
|
Formula in a Cell with condition?
|
Learner7 | Excel | 1 | 07-19-2010 10:10 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode