Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

2015-11-05 Thread Abhishek Jain
It works on all criteria at my end. Please see that you are entering characters without any spaces (before or after). Try copy pasting the characters for understanding. On Thu, Nov 5, 2015 at 7:01 PM, big smile wrote: > If i put 1A instead of A then it works > > On Thu, Nov 5, 2015 at 6:55 PM,

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

2015-11-05 Thread big smile
If i put 1A instead of A then it works On Thu, Nov 5, 2015 at 6:55 PM, big smile wrote: > Thanks a lot > > But if i put Table A then it shows 0 only. For Table A -- Both Risk Group > I /II not work.. > > On Thu, Nov 5, 2015 at 6:49 PM, Abhishek Jain > wrote: > >> PFA >> >> On Thu, Nov 5, 2015

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

2015-11-05 Thread big smile
Thanks a lot But if i put Table A then it shows 0 only. For Table A -- Both Risk Group I /II not work.. On Thu, Nov 5, 2015 at 6:49 PM, Abhishek Jain wrote: > PFA > > On Thu, Nov 5, 2015 at 6:20 PM, big smile wrote: > >> Repected Friends 1] Which formula I should use in E 13 --- I want the

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

2015-11-05 Thread Abhishek Jain
PFA On Thu, Nov 5, 2015 at 6:20 PM, big smile wrote: > Repected Friends 1] Which formula I should use in E 13 --- I want the > value depends upon Risk Group & Table As per B4 :D9 2] First I have to > see the Group which I & II then Table A/B/C/D It will take depends upon > this two criteria

$$Excel-Macros$$ Formula to take the value depends upon the two values

2015-11-05 Thread big smile
Repected Friends 1] Which formula I should use in E 13 --- I want the value depends upon Risk Group & Table As per B4 :D9 2] First I have to see the Group which I & II then Table A/B/C/D It will take depends upon this two criteria the value 3] I have to caluculate same way in more raws for