|
|
#2
02-11-2018, 02:47 PM
|
|||
|
|||
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","") 
|
|
|
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 Vista 
Office 2007
Threaded Mode