How can I write if condition to get the values ...

		Microsoft Office Forums > Microsoft Excel > Excel
How can I write if condition to get the values ...

12-15-2016, 02:50 AM

LearnerExcel LearnerExcel is offline

Windows 7 32bit How can I write if condition to get the values ...

Office 2003

Advanced Beginner

Join Date: Nov 2016

Posts: 82

Quote:

Originally Posted by xor

=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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
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 10:55 AM.