Hi The formula is saying If the value in cell C8 is not equal to the value in cell C7, then return the value of 1, otherwise, return the value of 0.
Regards Roger Govier Microsoft Excel MVP 2009/4/27 Ahmedhonest <ahmedhon...@gmail.com> > Dear Fabio Lemos, > > I appreciate your solution to the Query but may i know the logic of this > formula how it works plzzzzzzzzzzz > > *=IF(C8<>C7,1,0) <------------- Explain this plz* > > Regards > Ahmed > On Mon, Apr 27, 2009 at 4:31 PM, Fabio Lemos <flnle...@gmail.com> wrote: > >> Hi, >> You can use: >> >> =IF(C8<>C7,1,0) >> >> regards! >> >> 2009/4/27 Mayank Patel <mkpat...@gmail.com> >> >>> Dear Friends >>> >>> Please suggest the formula. >>> sample file is attached. >>> >>> Thanks to all in Advance >>> >>> >>> >>> Regards >>> Mayank Patel >>> ITC LTD >>> 9822978041 >>> 9422749110 >>> >>> >>> >> >> >> -- >> Fabio L Lemos >> >> email: flnle...@gmail.com >> >> >> >> > > > -- > Ahmed Bawazir > > > > > -- Roger Govier rogergov...@gmail.com --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---