Re: $$Excel-Macros$$ Required Formula to calculate rating

2011-08-13 Thread Simran Singh
Thank u so much Ashish. simran On Sat, Aug 13, 2011 at 12:07 PM, ashish koul wrote: > B8 > =IF(AND(COUNTIF(B2:B5,1)>=1,COUNTIF(B2:B5,0)=0),5,IF(AND(COUNTIF(B2:B5,1)=0,COUNTIF(B2:B5,0)>=1),1,5-COUNTIF(B2:B5,0))) > > =IF(COUNTIF(B2:B5,"NA")=COUNTA(B2:B5),"No > Rating",IF(AND(COUNTIF(B2:B5,1)>=1,C

Re: $$Excel-Macros$$ Required Formula to calculate rating

2011-08-12 Thread ashish koul
B8 =IF(AND(COUNTIF(B2:B5,1)>=1,COUNTIF(B2:B5,0)=0),5,IF(AND(COUNTIF(B2:B5,1)=0,COUNTIF(B2:B5,0)>=1),1,5-COUNTIF(B2:B5,0))) =IF(COUNTIF(B2:B5,"NA")=COUNTA(B2:B5),"No Rating",IF(AND(COUNTIF(B2:B5,1)>=1,COUNTIF(B2:B5,0)=0),5,IF(AND(COUNTIF(B2:B5,1)=0,COUNTIF(B2:B5,0)>=1),1,5-COUNTIF(B2:B5,0 O

RE: $$Excel-Macros$$ Required Formula to calculate rating

2011-08-12 Thread Rajan_Verma
May you please explain more how did you calculate rating, From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Simran Singh Sent: Saturday, August 13, 2011 10:07 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Required Formula to calculate ratin