$$Excel-Macros$$ Re: Condition Checking

2009-07-02 Thread TERTIUS KOSHY THOMAS
Hi Dilip, Swapnal, Vidyut, Bala and Satish, Thanks a million for your reply and solution!! Regards, -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of TERTIUS KOSHY THOMAS Sent: Monday, June 29, 200

$$Excel-Macros$$ Re: Condition Checking

2009-07-01 Thread Dilip Pandey
Hi Thomas, Your query has been solved and attached herewith. Thanks. Thanks & Regards -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Mon, Jun 29, 2009 at 6:52 AM, TERTIUS KOSHY THOMAS < tert...@hees.hitach

$$Excel-Macros$$ Re: Condition Checking

2009-06-29 Thread Swapnil Palande
Hi, Following formula will solve your problem: =IF(INT(LEFT(RC[-1], FIND("M", RC[-1])-2))<1000,1,"NA") I am also attaching file herewith. Regards, Swapnil. On Mon, Jun 29, 2009 at 6:52 AM, TERTIUS KOSHY THOMAS < tert...@hees.hitachi.com.sg> wrote: > > Hi all, > Can you help me with a small quer

$$Excel-Macros$$ Re: Condition Checking

2009-06-29 Thread bala
hi, use this formula : =IF(INT((LEFT(A2,LEN(A2)-1)))<1000,1,"NA") with regards BALA --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Vide

$$Excel-Macros$$ Re: Condition Checking

2009-06-29 Thread Sathish Jalendran
Hi, Please check the attached solution, let me know if it solves your query. Regards Sathish Jalendran From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of TERTIUS KOSHY THOMAS Sent: 29 June 2009 06:52 am To: excel-macros@googlegroups.com Subject: $$