Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-11-2018, 12:40 PM
LearnerExcel LearnerExcel is offline How to change the formula to get this result .... Windows 7 32bit How to change the formula to get this result .... Office 2003
Advanced Beginner
How to change the formula to get this result ....
 
Join Date: Nov 2016
Posts: 81
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default 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)
Reply With Quote
  #2  
Old 02-11-2018, 02:47 PM
jeffreybrown jeffreybrown is offline How to change the formula to get this result .... Windows Vista How to change the formula to get this result .... 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
  #3  
Old 02-11-2018, 08:26 PM
LearnerExcel LearnerExcel is offline How to change the formula to get this result .... Windows 7 32bit How to change the formula to get this result .... Office 2003
Advanced Beginner
How to change the formula to get this result ....
 
Join Date: Nov 2016
Posts: 81
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default

Thanks for the support.
Reply With Quote
Reply

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
How to change the formula to get this result .... formula for arriving at a result on condition msnarayanan Excel 2 07-28-2015 06:07 AM
How to change the formula to get this result .... formula, 2 criteria, one result cjdstephenson Excel 4 06-02-2015 09:17 PM
How to change the formula to get this result .... 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:25 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft