Thread: [Solved] How to change the formula to get this result ....
View Single Post
 
Old 02-11-2018, 02:47 PM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
  
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default
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","")
Reply With Quote