Microsoft Office Forums - View Single Post - How can I write if condition to get the values ...

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

View Single Post

Old

12-15-2016, 02:50 AM

LearnerExcel LearnerExcel is offline

LearnerExcel is offline

LearnerExcel uses Windows 7 32bit

Windows 7 32bit LearnerExcel uses Office 2003

LearnerExcel uses Office 2003

Office 2003

Advanced Beginner

The original poster

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

LearnerExcel 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