Hi Ahmed An IF statement has the following:
Firstly, the condition. Secondly, the result if the condition is met. Thirdly, the result if the condition is not met. Each of the above is separated by commas, so it looks like this: IF(Condition, Result if met, Result if not met) In your case, the condition is that C8 does not equal C7 In XL, we use '<>' to mean 'does not equal' So, in the formula: IF(C8<>C7,1,0) you see the 3 sections separated by commas, as described above. Firstly, the condition: C8<>C7 (C8 does not equal C7) Secondly, the result if the condition is met: 1 Thirdly, the result if the condition is not met: 0 Hope this helps. Regard - Dave. Date: Wed, 29 Apr 2009 23:24:02 +0100 Subject: $$Excel-Macros$$ Re: !!URGENT!! Formula Required Please HELP From: rogergov...@googlemail.com To: excel-macros@googlegroups.com 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 _________________________________________________________________ Looking for a fresh way to share photos? Get the new Windows Live Messenger. http://download.live.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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---