|
|
#1
02-11-2018, 12:40 PM
|
|||
|
|||
How to change the formula to get this result ....
How can I change the following formula to get the result like this ....
If D2 Cell first three characters are "C/O" then the D2 Cell value should be "M/S". Code:
=IF(ISBLANK([Template_PurchaseStatement.xls]Sheet1!$D2),"",[Template_PurchaseStatement.xls]Sheet1!$D2) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| IF Formula not returns result - Help | Haha88 | Excel | 6 | 02-11-2018 02:07 PM |
 formula for arriving at a result on condition
|
msnarayanan | Excel | 2 | 07-28-2015 06:07 AM |
|
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 |
| IF formula returns wrong result | mashley | Excel | 3 | 09-07-2012 07:03 AM |
Windows 7 32bit 
Office 2003
Threaded Mode