Thread: [Solved] How to change the formula to get this result ....
View Single Post
 
Old 02-11-2018, 12:40 PM
LearnerExcel LearnerExcel is offline Windows 7 32bit Office 2003
Advanced Beginner
  
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