Re: $$Excel-Macros$$ Required Passing formula (More confusing)

2012-09-05 Thread amar takale
Thanks very much for short formula On Wed, Sep 5, 2012 at 5:04 PM, Ms-Exl-Learner . wrote: > Or in one shot... > > =IF(SUMPRODUCT(--((F11:L11)<($F$10:$L$10))),"Failed","Passed") > > Refer the attached sheet for detail. > . > <><><><><><> > *Ms.Exl.Learner* > <><><><><><> > > > -- > > <><><><><><

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

2012-09-05 Thread Ms-Exl-Learner .
Or in one shot... =IF(SUMPRODUCT(--((F11:L11)<($F$10:$L$10))),"Failed","Passed") Refer the attached sheet for detail. . <><><><><><> *Ms.Exl.Learner* <><><><><><> -- <><><><><><> *Ms.Exl.Learner* <><><><><><> On Wed, Sep 5, 2012 at 1:24 PM, Manoj Kumar wrote: > Dear Amar, > > Please Use it

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

2012-09-05 Thread amar takale
Wow.Manoj. This will be grt help to me Thanks very much... On Wed, Sep 5, 2012 at 2:26 PM, Manoj Kumar wrote: > Dear Amar, > > Please find the attachment.. hope it will help you.. > > > Regard > Manoj > > > On Wed, Sep 5, 2012 at 1:43 PM, amar taka

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

2012-09-05 Thread Manoj Kumar
Dear Amar, Please find the attachment.. hope it will help you.. Regard Manoj On Wed, Sep 5, 2012 at 1:43 PM, amar takale wrote: > Hi Manoj, > Now I attached sheet.See it > > > On Wed, Sep 5, 2012 at 1:42 PM, amar takale wrote: > >> Hi Manoj, >> This is valuable formula for me,Thanks for it.B

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

2012-09-05 Thread amar takale
Hi Manoj, Now I attached sheet.See it On Wed, Sep 5, 2012 at 1:42 PM, amar takale wrote: > Hi Manoj, > This is valuable formula for me,Thanks for it.But I think it is also show > in short formula but now I forget it how to use it.I attached sheet with > your formula. Can you solved little more s

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

2012-09-05 Thread amar takale
Hi Manoj, This is valuable formula for me,Thanks for it.But I think it is also show in short formula but now I forget it how to use it.I attached sheet with your formula. Can you solved little more solution for Grade, I show Grade table in sheet. Thanks for your valuable time. Pls see it Thank yo

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

2012-09-05 Thread Manoj Kumar
Dear Amar, Please Use it... =IF(OR(F11<$F$10,G11<$G$10,H11<$H$10,I11<$I$10,J11<$J$10,K11<$K$10,L11<$L$10),"Failed","Pass") you can use conditional formatting to change color. Regard On Wed, Sep 5, 2012 at 1:20 PM, amar takale wrote: > Hi manoj, > If failed minmum one subject then show fail

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

2012-09-05 Thread amar takale
Hi manoj, If failed minmum one subject then show failed (required output in yellow) (looking Minmum marks on Row numbers 10) F10:L10. If anyone got marks less than minimum marks then show failed. On Wed, Sep 5, 2012 at 1:10 PM, Manoj Kumar wrote: > Dear amar, > > Please tell what is passing mark

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

2012-09-05 Thread Manoj Kumar
Dear Amar, Please Use it... =IF(OR(F11<$F$10,G11<$G$10,H11<$H$10,I11<$I$10,J11<$J$10,K11<$K$10,L11<$L$10),"Failed","Pass") Regard Manoj On Wed, Sep 5, 2012 at 1:10 PM, Manoj Kumar wrote: > Dear amar, > > Please tell what is passing marks... > > Regard > Manoj > > On Wed, Sep 5, 2012 at 1:06 P

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

2012-09-05 Thread Manoj Kumar
Dear amar, Please tell what is passing marks... Regard Manoj On Wed, Sep 5, 2012 at 1:06 PM, amar takale wrote: > Hi All Experts, > Pl solved challenging formula for passing. > > Appreciate the help very much > > -- > Join official facebook page of this forum @ > https://www.facebook.com/disc