$$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