Re: $$Excel-Macros$$ Need if formula

2012-03-07 Thread NOORAIN ANSARI
n but, depending on your need you >>> could use LOOKUP, vLookup >>> >>> Don Guillett >>> Microsoft MVP Excel >>> SalesAid Software >>> dguille...@gmail.com >>> >>> *From:* Ashish Bhalara >>> *Sent:* Tuesday, March

Re: $$Excel-Macros$$ Need if formula

2012-03-07 Thread dguillett1
, depending on your need you could use LOOKUP, vLookup Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ashish Bhalara Sent: Tuesday, March 06, 2012 10:14 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need if

Re: $$Excel-Macros$$ Need if formula

2012-03-07 Thread Rajasekhar Praharaju
, March 06, 2012 10:14 PM >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ Need if formula >> >> Dear expert, >> >> If function used maximum 7 time in an function, if the requirement of >> condition if is more than 7, what is the function

Re: $$Excel-Macros$$ Need if formula

2012-03-07 Thread Rajasekhar Praharaju
m > > *From:* Ashish Bhalara > *Sent:* Tuesday, March 06, 2012 10:14 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Need if formula > > Dear expert, > > If function used maximum 7 time in an function, if the requirement of > condition if is m

Re: $$Excel-Macros$$ Need if formula

2012-03-07 Thread dguillett1
You didn’t show us your situation but, depending on your need you could use LOOKUP, vLookup Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ashish Bhalara Sent: Tuesday, March 06, 2012 10:14 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need

Re: $$Excel-Macros$$ Need if formula

2012-03-06 Thread Seraj Alam
Hi, In 200 version u can use only 7 if condition however in 2007 and later version u can use 64 if condition... Thanks seraj On Tue, Mar 6, 2012 at 8:14 PM, Ashish Bhalara wrote: > Dear expert, > > If function used maximum 7 time in an function, if the requirement of > condition if is more th

Re: $$Excel-Macros$$ Need if formula

2012-03-06 Thread Ashish Bhalara
Dear expert, If function used maximum 7 time in an function, if the requirement of condition if is more than 7, what is the function used or which type of condition are need to fulfill 10 different condition? Thanks & regards Ashish Bhalara On Tue, Mar 6, 2012 at 5:05 PM, Sharad Gupta < sharadg

Re: $$Excel-Macros$$ Need if formula

2012-03-06 Thread Sharad Gupta
On Tue, 06 Mar 2012 14:42:54 +0530 wrote >hi Experts, please provide if condition formula for attached sheet. Thanks,Rekah -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formu

Re: $$Excel-Macros$$ Need if formula

2012-03-06 Thread Maries
Try this formula... =IF(A1>2,"Check",IF(A1<0,"Okay","Safe")) On Tue, Mar 6, 2012 at 1:17 PM, Maries wrote: > *Try it..* > =IF(A2<2,"Okay",IF(A2>2,"Needs Change","Safe")) > On Tue, Mar 6, 2012 at 1:14 PM, Abhishek Jain wrote: > >> 0-1 = Okay >> 2 = Safe >> > 2 = Needs change >> >> Use this formu

Re: $$Excel-Macros$$ Need if formula

2012-03-06 Thread Maries
*Try it..* =IF(A2<2,"Okay",IF(A2>2,"Needs Change","Safe")) On Tue, Mar 6, 2012 at 1:14 PM, Abhishek Jain wrote: > 0-1 = Okay > 2 = Safe > > 2 = Needs change > > Use this formula - > > =IF(A2<2,"Okay",IF(A2>2,"Needs Change","Safe")) > > > > > On Tue, Mar 6, 2012 at 2:42 PM, Abhishek Jain wrote: > >

Re: $$Excel-Macros$$ Need if formula

2012-03-06 Thread Abhishek Jain
0-1 = Okay 2 = Safe > 2 = Needs change Use this formula - =IF(A2<2,"Okay",IF(A2>2,"Needs Change","Safe")) On Tue, Mar 6, 2012 at 2:42 PM, Abhishek Jain wrote: > Aren't less then 2 and between 0-2 are the same conditions ? > > > > On Tue, Mar 6, 2012 at 2:34 PM, rekha siri wrote: > >> hi Expe

Re: $$Excel-Macros$$ Need if formula

2012-03-06 Thread Abhishek Jain
Aren't less then 2 and between 0-2 are the same conditions ? On Tue, Mar 6, 2012 at 2:34 PM, rekha siri wrote: > hi Experts, > > please provide if condition formula for attached sheet. > > Thanks, > Rekah > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accu