Re: $$Excel-Macros$$ Alternative to OR condition

all the ways you can, >> In all the places you can, >> At all the times you can, >> To all the people you can, >> As long as ever you can.” - John Wesley >> *- >> >> >> ------ >> *From:*

Re: $$Excel-Macros$$ Alternative to OR condition

> -- > *From:* Jorge Marques > *To:* excel-macros@googlegroups.com > *Sent:* Tue, July 31, 2012 7:57:43 AM > > *Subject:* Re: $$Excel-Macros$$ Alternative to OR condition > > Nice :), I use a lot IFERROR, I´ll do it with ISNA, keeping it simple. &g

Re: $$Excel-Macros$$ Alternative to OR condition

the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Jorge Marques To: excel-macros@googlegroups.com Sent: Tue, July 31, 2012 7:57:43 AM Subject: Re: $$Excel-Macros$$ Alterna

Re: $$Excel-Macros$$ Alternative to OR condition

__ From: Jorge Marques To: excel-macros@googlegroups.com Sent: Tue, July 31, 2012 7:41:25 AM Subject: Re: $$Excel-Macros$$ Alternative to OR condition Noorain what does exactly "ISNA"? I used +IFERROR(IF(MATCH($C6;$A$4:$A$11;0);D1;"");E1) is it the same principle for IFerror? 2012/7/31 H

Re: $$Excel-Macros$$ Alternative to OR condition

Most Welcome Bro.. On Tue, Jul 31, 2012 at 5:27 PM, Jorge Marques wrote: > Nice :), I use a lot IFERROR, I´ll do it with ISNA, keeping it simple. > thank you very much. > > > 2012/7/31 NOORAIN ANSARI > >> Dear Jorge, >> >> The #N/A error happens most often when a lookup function cannot find a >

Re: $$Excel-Macros$$ Alternative to OR condition

Nice :), I use a lot IFERROR, I´ll do it with ISNA, keeping it simple. thank you very much. 2012/7/31 NOORAIN ANSARI > Dear Jorge, > > The #N/A error happens most often when a lookup function cannot find a > result. You can manually remove the all of your #N/As or you can stop them > in your ori

Re: $$Excel-Macros$$ Alternative to OR condition

Dear Jorge, The #N/A error happens most often when a lookup function cannot find a result. You can manually remove the all of your #N/As or you can stop them in your original formula. A simple and effective way of trapping the #N/A errors and replacing them with whatever you would like is to use t

Re: $$Excel-Macros$$ Alternative to OR condition

Noorain what does exactly "ISNA"? I used +IFERROR(IF(MATCH($C6;$A$4:$A$11;0);D1;"");E1) is it the same principle for IFerror? 2012/7/31 Hilary Lomotey > Perfect, thanks Noorain, it works > > > On Tue, Jul 31, 2012 at 10:24 AM, NOORAIN ANSARI > wrote: > >> Hi Hilary, >> >> Please try it.. >> >>

Re: $$Excel-Macros$$ Alternative to OR condition

Perfect, thanks Noorain, it works On Tue, Jul 31, 2012 at 10:24 AM, NOORAIN ANSARI wrote: > Hi Hilary, > > Please try it.. > > *=+IF(ISNA(MATCH(C4,$A$4:$A$6,0)),E1,D1)* > Hope it help to you. > > see the attached sheet. > > -- > With Regards, > Noorain Ansari > http:// >

Re: $$Excel-Macros$$ Alternative to OR condition

Hi Hilary, Please try it.. *=+IF(ISNA(MATCH(C4,$A$4:$A$6,0)),E1,D1)* Hope it help to you. see the attached sheet. -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclin

Re: $$Excel-Macros$$ Alternative to OR condition

Thnks Marques, but not sure i follow your suggestion, can you be more explicit. thanks On Tue, Jul 31, 2012 at 10:06 AM, Jorge Marques wrote: > Do you the C4 to CX if it founds the value on column A it returns D1 else > if the C4 to Cx isn´t on column A returns E1? > > > 2012/7/31 Hilary Lomotey

Re: $$Excel-Macros$$ Alternative to OR condition

Do you the C4 to CX if it founds the value on column A it returns D1 else if the C4 to Cx isn´t on column A returns E1? 2012/7/31 Hilary Lomotey > Hello Experts > > is there another way to write an OR formula . Example, i want to exempt > some people from say tax, so i list them and write a form

$$Excel-Macros$$ Alternative to OR condition

Hello Experts is there another way to write an OR formula . Example, i want to exempt some people from say tax, so i list them and write a formula that +IF(OR(C4=$A$4,C4=$A$5,C4=$A$6),D1,E1). But this can be painful if the list is long, i tried using +IF(C4=$A$4:$A$17,D1,E1), but it only gets it w