small correction - probably shivaranjini men't you would need to visit the excel help to know all the formulas in use.
-----Original Message----- From: AccessIndia [mailto:[email protected]] On Behalf Of Shivaranjini Ranjini Sent: 01 December 2012 15:27 To: [email protected] Subject: Re: [AI] Excel formula On 12/1/12, Aliasgar Fakhri <[email protected]> wrote: > Hi, pls try out the following. > Do let me know if any other assistance is required. > > =IF(LEFT(B3,1)="d",0,"") > > Above formula in cell a3 states, that for any alphanumerical value in > cell b3, if it starts with d ( its leftmost character ), the value to > be returned will be 0. > If it does not satisfy the criteria, then "Null" value would be > presented, indicating Blank field. > > Regards. > > > > On Sat, Dec 1, 2012 at 8:27 AM, Mukesh <[email protected]> > wrote: > >> Dear Friends, >> Please suggest/correct the formula. >> Condition: if any value in cell 'b2' starts with a letter 'd' the >> cell value of cell 'a1' should change in 0. In other words the value >> of cell 'a1' should not accept any value except 0, validation required. >> >> formula: >> =if(a2,"=any value starting with a letter 'd'","0") >> >> It's very urgent so please suggest/correct this formula at the earliest. >> Waiting for your guidance at the earliest. Thank you. >> >> Regards >> >> Mukesh Baviskar >> Mobile: 0943161157 >> Skype id: mukeshbaviskar >> Register at the dedicated AccessIndia list for discussing >> accessibility of mobile phones / Tabs on: >> >> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_ac >> cessindia.org.in >> >> >> Search for old postings at: >> http://www.mail-archive.com/[email protected]/ >> >> To unsubscribe send a message to >> [email protected] >> with the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please visit the list home page at >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.or >> g.in >> >> > > > -- > Regards, > AliAsgar H.Fakhri > Register at the dedicated AccessIndia list for discussing > accessibility of mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_acc > essindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/[email protected]/ > > To unsubscribe send a message to > [email protected] > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, > please visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org > .in > > you want all excel formullas? you go to jaws help and search there Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessind ia.org.in Search for old postings at: http://www.mail-archive.com/[email protected]/ To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/[email protected]/ To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
