try this
=IF((C2/A2)>100%,100%,(C2/A2))
On Tue, Mar 5, 2013 at 4:24 PM, Shaikh Iqbal wrote:
> Please explain
>
>
> On 5 March 2013 16:20, xlstime wrote:
>
>> so you can use same formula with if condition
>>
>> On Tue, Mar 5, 2013 at 4:16 PM, Shaikh Iqbal wrote:
>>
>>> Hi,
>>>
>>> If may Prod (
so you can use same formula with if condition
On Tue, Mar 5, 2013 at 4:16 PM, Shaikh Iqbal wrote:
> Hi,
>
> If may Prod (On+Off Rte) > CallPlan then output in column only 100% not
> goes to 126%
>
>
> On 5 March 2013 16:06, xlstime wrote:
>
>> Hi Shaikh,
>>
>> something is missing in your data
Hi Shaikh,
something is missing in your data
what is the mean of Column D (% (On+Off Rte)) ... i thing Column A (Call
Pln) + Column B(Prod (On Rte))
if yes then put formula in column d = A2/C2
Enjoy
Team XLS
On Tue, Mar 5, 2013 at 4:01 PM, Shaikh Iqbal wrote:
> Dear Export,
>
> Please
Thanks Noorin,
On Fri, Feb 3, 2012 at 3:21 PM, NOORAIN ANSARI wrote:
> Dear Chandra,
>
> Please use..
>
> =VLOOKUP(C3,$C$9:$H$13,MATCH($C$1,$C$7:$H$7,0),0)
> or
> =SUMPRODUCT((PROD=C3)*($D$7:$H$7=C1)*($D$9:$H$13))
> or
> =INDEX($D$9:$H$13,MATCH(C3,PROD,0),MATCH(C1,$D$7:$H$7,0))
>
> See attached
Dear Chandra,
Please use..
=VLOOKUP(C3,$C$9:$H$13,MATCH($C$1,$C$7:$H$7,0),0)
or
=SUMPRODUCT((PROD=C3)*($D$7:$H$7=C1)*($D$9:$H$13))
or
=INDEX($D$9:$H$13,MATCH(C3,PROD,0),MATCH(C1,$D$7:$H$7,0))
See attached Sheet.
On Fri, Feb 3, 2012 at 3:13 PM, chandra sekaran wrote:
> Hi Noorin
>
> Excell She
Hi Noorin
Excell Sheet attached
Chandru
On Fri, Feb 3, 2012 at 3:02 PM, NOORAIN ANSARI wrote:
> Dear Chandra,
>
> Please share sample sheet
>
> On Fri, Feb 3, 2012 at 2:37 PM, chandra sekaran
> wrote:
>
>> Dear all,
>>
>> Sheet 1 having below data Month wise product details sheet 2
Dear Chandra,
Please share sample sheet
On Fri, Feb 3, 2012 at 2:37 PM, chandra sekaran wrote:
> Dear all,
>
> Sheet 1 having below data Month wise product details sheet 2 if i
> select Jan -12 then Product A selection qty will come 100what is
> the formula any one help me
>
Please could you be a little more clear what you want. It is very hard to
understand what you have written. Also, please avoid this practice of
writing your requirement IN the file. The email text area is given to type
in your text, not just to attach files.
Sam
On Wed, Feb 1, 2012 at 8:38 PM, ch
