Re: $$Excel-Macros$$ Fill the formula in yellow using "IF" function!!!

2016-07-19 Thread Murali Nagarajan
Dear Sachin, PFA On Tue, Jul 19, 2016 at 4:59 PM, सचिन शर्मा wrote: > Thanks Paul, > > For answer and your observation, > > Now it's working correctly. > > Regards. > > *Sachin* > > # +91 97 16 437516 > # +91 72 91 932360 > > On Tuesday, July 19, 2016 at 4:51:00 PM UTC+5:30, Paul Schreiner wro

Re: $$Excel-Macros$$ Fill the formula in yellow using "IF" function!!!

2016-07-19 Thread सचिन शर्मा
Thanks Paul, For answer and your observation, Now it's working correctly. Regards. *Sachin* # +91 97 16 437516 # +91 72 91 932360 On Tuesday, July 19, 2016 at 4:51:00 PM UTC+5:30, Paul Schreiner wrote: > > I think your logic MAY be flawed. > > In your example, TL2 has: > 95 94 78 > > Data

Re: $$Excel-Macros$$ Fill the formula in yellow using "IF" function!!!

2016-07-19 Thread Paul Schreiner
I think your logic MAY be flawed. In your example, TL2 has:95 94 78 Data1 (95) matches Bucket B.Data2 (94) matches Bucket A.Data3 (78) matches Bucket B. so 0 should be returned? Based on your criteria, none of the Team Leaders would receive "Incentive". Is that correct?---If you changed your crite

Re: $$Excel-Macros$$ Fill the formula in yellow using "IF" function!!!

2016-07-19 Thread Sachin Panchal
Dear sachin try this i hope your problem will be solve with my rule On Tue, Jul 19, 2016 at 12:42 PM, सचिन शर्मा wrote: > Dear All, > > > > PFA, > > > > Calculate the incentive according 3 data base ( *DATA 1, DATA 2, DATA 3*) > and 3 different grads ( *A, B, C* ) > > > > Criteria and achieveme

$$Excel-Macros$$ Fill the formula in yellow using "IF" function!!!

2016-07-19 Thread सचिन शर्मा
Dear All, PFA, Calculate the incentive according 3 data base ( *DATA 1, DATA 2, DATA 3*) and 3 different grads ( *A, B, C* ) Criteria and achievement both in attached sheet. Regards. *Sachin* # +91 97 16 437516 # +91 72 91 932360 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i