$$Excel-Macros$$ Re: if condition based on two cell value

Hi Ayush Thank you so much & keep up the great support. On 10/18/09, Ayush Jain wrote: > > Hi Mahesh, > > The OR,AND formula can be used as : > OR(Logical test 1, Logical Test 2, ..) > AND(Test 1, Test 2,.) > > =IF(OR(B26= "Add R",B26 = "CC"),"Req",IF(B26 = > "Entered","WIP",IF(C26="B

$$Excel-Macros$$ Re: if condition based on two cell value

Hi Mahesh, The OR,AND formula can be used as : OR(Logical test 1, Logical Test 2, ..) AND(Test 1, Test 2,.) =IF(OR(B26= "Add R",B26 = "CC"),"Req",IF(B26 = "Entered","WIP",IF(C26="Bounce","Bounce",IF(OR(B26="Cancel",B26="NTU",B26="Decline"),"Refund","PP" You can use above formula for

$$Excel-Macros$$ Re: IF condition formula

Use sumifs which is a new function in 2007. this is very easy On Tue, Aug 25, 2009 at 5:53 PM, suresh k wrote: > > Can anyone provide me the formula for below query. > >Report Date Total Logged Time at Work Hrs 7/2/2009 8.86 7/2/2009 9.03 > 7/2/2009 7.92 7/2/2009 9.02 7/3/2009 9.05 > Answer

$$Excel-Macros$$ Re: IF condition formula

Please see the attached file.   You'll have to do few adjustments to work it out   Joby --- On Tue, 25/8/09, suresh k wrote: From: suresh k Subject: $$Excel-Macros$$ IF condition formula To: "Excel group" Date: Tuesday, 25 August, 2009, 5:53 PM Can anyone provide me the formula for below q

$$Excel-Macros$$ Re: IF condition formula

Thanks Harmeet..!! But, I must say that the solution provided by Paul is also good, the only limitation which I can see in it is that It won't work in Excel 2003 / xp or versions below than that. Suresh.. the Brave man... if you have Excel 2007 version installed in your PC, then please go ahead an

$$Excel-Macros$$ Re: IF condition formula

I think Dilip has already provided the solution. plese refer to attached file. On Tue, Aug 25, 2009 at 5:53 PM, suresh k wrote: > > Can anyone provide me the formula for below query. > >Report Date Total Logged Time at Work Hrs 7/2/2009 8.86 7/2/2009 9.03 > 7/2/2009 7.92 7/2/2009 9.02 7

$$Excel-Macros$$ Re: IF condition formula

Try =SUMIFS (not SUMIF, but SUMIFS) the plural means multiple conditions!!! the function Wizard makes it very easy to use. But your formula becomes: =SUMIFS(B2:B6,A2:A6,"7/2/2009",B2:B6,">8") Sums B2-B6, if A2-A6 is "7/2/2009" and if B2-B6 is > 8. hope this helps. Paul __

$$Excel-Macros$$ Re: IF condition formula

Ok..I think tomorrow, we can discuss on this over Gtalk. If you want you can draft your queries as well and sent that to the group. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Aug 25, 2009 at 6

$$Excel-Macros$$ Re: IF condition formula

Hi Suresh.. the Brave man.!! Attached workbook has the solution to your query. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Aug 25, 2009 at 5:06 PM, suresh k wrote: > Hi Dilip, > > Could yo

$$Excel-Macros$$ Re: IF Condition

=AND(B4>5,E4>2,H4>2) Use above formula and filter wit TRUE On Fri, Aug 7, 2009 at 9:53 PM, Ravi Kumar Vandavasi < friendswrite...@gmail.com> wrote: > > > =IF(B4>5,IF(E4>2,IF(H4>2,"Yes","No"), "No"), "NO") > > On Aug 6, 5:53 pm, Putta Madaiah wrote: > > Hi All, > > > > Can anyone provide me the

$$Excel-Macros$$ Re: IF Condition

=IF(B4>5,IF(E4>2,IF(H4>2,"Yes","No"), "No"), "NO") On Aug 6, 5:53 pm, Putta Madaiah wrote: > Hi All, > > Can anyone provide me the formulas as per the requirement in the attachment. > > Rgds, > Putta - Bangalore > >  Formula.xlsx > 35KViewDownload --~--~-~--~~~---~-

$$Excel-Macros$$ Re: IF Condition

Hi, Attached workbook with solution. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Aug 6, 2009 at 6:23 PM, Putta Madaiah wrote: > Hi All, > > Can anyone provide me the formulas as per the requ