#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
You can't use a formula to look at the contents of D2 and then change D2 based on the contents of D2. You can't have a cell with both a formula and a value at the same time.
What are you trying to do? If you are trying to achieve a result in another cell bases on the contents of D2... =IF(LEFT(Sheet1!$D2,3)="C/O","M/S","") |
#3
|
|||
|
|||
Thanks for the support.
|
Thread Tools | |
Display Modes | |
|
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 |