Hi Hanumant, Try it: =IF(A1:A14="a",1,"0")
On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde <hanumant_5...@yahoo.co.in>wrote: > Hi Friends, > > I want to use IF condition like i used below but its no working. > I used below formula. > ={IF($A$8:$A$14="a",1,"")} > > f d s d f g a . > . > . > and so on > > this is my data which is random. > i want to write if any of the row in above data has "a" then write 1 else > 0. if condition will come only once not for all the rows. > i dont wanna use macro nor OR as data can be large. > > Thanks > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- With Regards Ankur Saraswat -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel