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
Dear Export,
Please help me attached file.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titl
Dear expert,
I have a data in attached sheet, in which data contain opng balance,
transaction & closing balance of particular month and code, i need a
formula to calculate sum opening balance of month wise on base of code, the
data file is attached herewith for my requirement.
Thanks & regards.
: 05 May 2012 16:58
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ $$Excel-Macros$$ $$Excel-Macros$$ Formula Need
for difference between days
Hi,
Find the attachment.
Regards,
MARIES.
On Fri, May 4, 2012 at 11:03 PM, Vijayendra Rao
wrote:
Dear Deba Ranjan
Hi,
Find the attachment.
Regards,
MARIES.
On Fri, May 4, 2012 at 11:03 PM, Vijayendra Rao wrote:
> Dear Deba Ranjan,
>
> Thanks for efforts, I knew this formula and it was not solved my problem.
>
> I need the below details if any one worked 4th October 2011 to 4th May 2012
> - Total days
Dear Deba Ranjan,
Thanks for efforts, I knew this formula and it was not solved my problem.
I need the below details if any one worked 4th October 2011 to 4th May 2012
- Total days worked in which beginning of the month, i.e: 4th oct to 31 st
oct is 28 days, It should be zero if he worked full mo
*Hi *Vijay,
You can you try formula, it will help you out.:-
For Date diffrence:- =DATEDIF(A2,(B2),"md")
For Month diffrence :- =DATEDIF(A2,(B2),"ym")
For Year diffrence :- =DATEDIF(A2,(B2),"y")
Thanks & Regards,*
*
*Deba Ranjan P***
On Fri, May 4, 2012 at 12:39 PM, Vijayendra Rao w
Dear All,
I need date formula for finding how many days and months between two
different dates. Request you to resolve my query. I have attached is the
same file.
Regards,
Vijayendra
94491 67631
--
ಧನ್ಯವಾದಗಳು,
ವಿಜಯೇಂದ್ರ,
೯೪೪೯೧ ೬೭೬೩೧
Regards,
Vijayendra
94491 67631
--
FORUM RULES (986
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
>
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
Jan-12 Feb-12 Mar-12 Apr-12 May-12 * * * *
* * PRODUCT A 100 * *
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
Hi all
I need Formula which attached sheet any one help me
Regads
chandu
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
q
17 matches
Mail list logo
