Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page How can I write if condition to get the values ...
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 12-15-2016, 01:13 AM
LearnerExcel LearnerExcel is offline How can I write if condition to get the values ... Windows 7 32bit How can I write if condition to get the values ... Office 2003
Advanced Beginner
How can I write if condition to get the values ... 		 
Join Date: Nov 2016
Posts: 81
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default How can I write if condition to get the values ...
I want to check the following condition to get the result like ...

If cell A1 first letter is 4, then it should take the value of cell A2 and copy it in to cell B1
Else
It should take the value of cell A1 and copy the same in to cell B2

How can I do that?
Reply With Quote
  #2  
Old 12-15-2016, 01:35 AM
xor xor is offline How can I write if condition to get the values ... Windows 10 How can I write if condition to get the values ... Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
=if((--(left(a1,1))=4),a2,a1)
Reply With Quote
  #3  
Old 12-15-2016, 02:50 AM
LearnerExcel LearnerExcel is offline How can I write if condition to get the values ... Windows 7 32bit How can I write if condition to get the values ... Office 2003
Advanced Beginner
How can I write if condition to get the values ... 		 
Join Date: Nov 2016
Posts: 81
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default
Quote:
Originally Posted by xor View Post
=if((--(left(a1,1))=4),a2,a1)
Thanks a lot for your kind help. One more support required to avoid #Value! error and make the cell blank which has error.
Reply With Quote
  #4  
Old 12-15-2016, 03:10 AM
xor xor is offline How can I write if condition to get the values ... Windows 10 How can I write if condition to get the values ... Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
=iferror(if((--(left(a1,1))=4),a2,a1),"")
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I write if condition to get the values ... How can I sum values using SumIfs condition like ... LearnerExcel Excel 6 11-28-2016 09:45 PM
Display multiple values as new values based on selection from template. MvdB Excel 2 09-29-2015 08:51 PM
write need help and copy write need help on another page auto wykoems Word 2 07-25-2013 07:56 AM
How can I write if condition to get the values ... check with condition karti Word 2 03-15-2011 06:06 AM
Retrict Method Condition markp Outlook 0 12-22-2005 05:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:05 PM.

Contact Us - Privacy Statement - Top

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