Dear Abhishek & Paul Sir,
Its really cool formula which exact I want … Now There are a glow on my
face.
Thanks Once again both of you Sirji.
Regards
AmarT
On Wed, Mar 2, 2016 at 5:57 PM, Paul Schreiner
wrote:
> It looks like your formula is working as expected (?)
>
> You're using:
> =IF
It looks like your formula is working as expected (?)
You're using:=IF(AND(C12="",D12=""),"",IF(C12<>"",C12,D12))
Based on your logic:If both C & D are blanks, return blank.
If C has a value and D doesn't, return C.
If D has a value and C doesn't, return D.
If both C & D has a value, return C.
is a
Please see attached.
HTH
On Wed, Mar 2, 2016 at 10:28 AM, amar takale wrote:
> Dear Paul Sir
>
> Pls look into this topic.I think we will use (If+Search) formula but I
> cant possible how to modified it.
>
> Regards
> Amar
>
> On Mon, Feb 29, 2016 at 7:49 PM, amar takale wrote:
>
>>
>> --
>> A
Dear Paul Sir
Pls look into this topic.I think we will use (If+Search) formula but I cant
possible how to modified it.
Regards
Amar
On Mon, Feb 29, 2016 at 7:49 PM, amar takale wrote:
>
> --
> 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) ! Joi
--
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 titles, like Please Help,
Urgent, Need Help, F
Hi
Also you may be required to set myAddIn.Installed = True when condition is
met,, because once addin is disabled it wont get automatically
enabled/installed.
CHeers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Sep 23, 2014 at 10:06 AM, my excel wrote:
thanks a lot sir
On Mon, Sep 22, 2014 at 3:41 AM, Vaibhav Joshi wrote:
> Hi
>
> Use this code:
>
> Sub CompName()
>
> Dim ThisComputerName As String
> Dim myAddIn As AddIn
>
> If UCase(Environ("computername")) = "PCEARTH" Then
> ActiveSheet.Range("S1").Value = "INDIA"
>
Hi
Use this code:
Sub CompName()
Dim ThisComputerName As String
Dim myAddIn As AddIn
If UCase(Environ("computername")) = "PCEARTH" Then
ActiveSheet.Range("S1").Value = "INDIA"
Else
MsgBox ("Sorry You are Not a Authorised User")
' below sub programs must b
Sir,
i created an add-in for my excel work
but i am trying to write a condition it will only run in Computer Name=
PCEARTH
otherwise sub programs will be disabled automatically or not working
thanks
Sub CompName()
Dim tSName As String
Dim ThisComputerName As String
ThisComputerNa
This should work --
=IF(G2>1,0,IF(AND(C2<41000,G2*8.33%>3500),3500,IF(AND(C2<41000,G2*8.33%<3500),G2*8.33%,((41365-C2)*G2*8.33%)/365)))
Although this is based on conditions you told but I think your two
conditions are contradictory. See, 3500 bonus will be when bonus wage is
42017...which and
This should work --
=IF(G2>1,0,IF(AND(C2<41000,G2*8.33%>3500),3500,IF(AND(C2<41000,G2*8.33%<3500),G2*8.33%,((41365-C2)*G2*8.33%)/365)))
On Tue, Mar 12, 2013 at 1:50 PM, Prabhakar S H wrote:
> 8.33% on Bonus Wage.
>
> On Tuesday, March 12, 2013 11:48:37 AM UTC+5:30, Abhi wrote:
>
>> 8.33% of
8.33% on Bonus Wage.
On Tuesday, March 12, 2013 11:48:37 AM UTC+5:30, Abhi wrote:
> 8.33% of what ?
>
> One should not suppose that all people have similar understanding of
> problem as the person who is asking for a solution. Last time also, you
> missed several things. Please give complete e
8.33% of what ?
One should not suppose that all people have similar understanding of
problem as the person who is asking for a solution. Last time also, you
missed several things. Please give complete explanation.
PS: I could not understand anything from that sample calculation.
On Tue, Mar 12,
On Monday, March 11, 2013 5:42:36 PM UTC+5:30, shrini wrote:
>
> Dear Prabhakar
> Please clear Following things
> 1.What is full year (how much Bonus wage is full year) - Full year means
> FY (from 01.04.2012 to 31.03.2013)
>
> 2.In body of mail u r showing greater than 1 but in Sheet u r
Dear Abhi,
i missed to inform
8.33% with a maxim cap of 3500rs as bonus and for salary less than 10k.
On Monday, March 11, 2013 6:10:55 PM UTC+5:30, Abhi wrote:
> Paste in H2 and drag down.
>
> =IF(AND(C2<41000,G2<=1),3500,IF(G2>1,0,((41365-C2)*3500)/365))
>
> This is based on foll
Paste in H2 and drag down.
=IF(AND(C2<41000,G2<=1),3500,IF(G2>1,0,((41365-C2)*3500)/365))
This is based on following assumptions:
- Bonus is calculated till 31.03.2013 @ Rs. 3500 for 365 days if bonus
wage is <= 1 and employee joined before 1.4.12 (which means he worked
for
Dear Prabhakar
Please clear Following things
1.What is full year (how much Bonus wage is full year)
2.In body of mail u r showing greater than 1 but in Sheet u r writing
less than 1
3.What is prorata basis
Regards
Shrinivas
On Mon, Mar 11, 2013 at 4:03 PM, Prabhakar S H wrote:
> Hi Tea
Hi Team,
in attached sheet i need to put If condition to get Bouns Amount of Rs
3500/- based on the below criteria:
= if Bonus Wage is >1 then Zero
= if he worked full year then need to pay 3500/-
= if he joined in between the year then need to pay on prorata basis
Pls help.
Rgds,
Pra
MATCH(1,2:2,-1)))
>> copy down
>>
>> Don Guillett
>> Microsoft Excel Developer
>> SalesAid Software
>> dguille...@gmail.com
>>
>> *From:* mailto:in.vaib...@gmail.com
>> *Sent:* Tuesday, August 28, 2012 11:51 PM
>> *To:* excel-macros@googleg
,-1)),"",INDEX($1:$1,0,MATCH(1,2:2,-1)))
> copy down
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> *From:* mailto:in.vaib...@gmail.com
> *Sent:* Tuesday, August 28, 2012 11:51 PM
> *To:* excel-macros@googlegroups.com
>
=IF(ISNA(MATCH(1,2:2,-1)),"",INDEX($1:$1,0,MATCH(1,2:2,-1)))
copy down
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: mailto:in.vaib...@gmail.com
Sent: Tuesday, August 28, 2012 11:51 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Ex
PFA Sample Data, if we can do with formula or vba both option is welcome.
Rgds
Vaibhav
On Tue, Aug 28, 2012 at 11:34 PM, wrote:
> Hi All
>
> I have a tracker with almost 10 condition to be tasted. All condition is
> shown as header, for case 1 when first event is completed then date of
> completi
Dear vaibhav,
Can you share sample worbook with group
Sent from BlackBerry® on Airtel
-Original Message-
From: in.vaib...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 28 Aug 2012 18:04:01
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ If condition
Subject: $$Excel-Macros$$ If condition limitation.
Hi All
I have a tracker with almost 10 condition to be tasted. All condition is
shown as header, for case 1 when first event is completed then date of
completion is put under 1st header and under status for case 1 value to be
reflected is
Hi All
I have a tracker with almost 10 condition to be tasted. All condition is shown
as header, for case 1 when first event is completed then date of completion is
put under 1st header and under status for case 1 value to be reflected is
description of header 1.
When second event is completed
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prajakt Pande
Sent: 29 April 2012 16:58
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ IF CONDITION IN USERFORM
Dear everyone,
Referring to subject line attached a excel file with user form, my q
Dear everyone,
Referring to subject line attached a excel file with user form, my question
is
if text box 1 is “” (blank) then while moving cursor to combo box 1 it
shows msgbox with “please enter name” if this condition fulfill (means user
enter the name in textbox1 then it not supposed
*Can you show sample OUTPUT in another column...*
*
*
On Sat, Apr 21, 2012 at 1:16 AM, Ashish Bhalara
wrote:
> Dear sir,
>
> I want to write the cell address to fulfill formula, is there any solution
> for it?
>
> Ashish
>
>
> On Sat, Apr 21, 2012 at 12:29 PM, Waseem Saifi wrote:
>
>>
>> I hope th
I hope this will help You Ashish.
On Fri, Apr 20, 2012 at 11:46 PM, Ashish Bhalara
wrote:
> Dear expert,
>
> I use date in if formula but not work in attached file, please know me the
> my mistake.
>
> Thanks & regards
>
> Ashisih Bhalara
>
> --
> FORUM RULES (986+ members already BANNED for vi
It working fine in this file, your formula is fully qualified your
conditions
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ashish Bhalara
Sent: Apr/Sat/2012 12:16
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ If condition
Hi Raj Kumar
Just solved this query for Anil, please check my reply and if not able to
find the same do get back to me.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Fri, Apr 9, 2010 a
Hello Dear
You can use Multiple if Condition
&
Conditional Formatting.
Please have a look on attached sheet...
Hope it Will Help
Happy To Help
:)
Prashant Tripathi
On Fri, Apr 9, 2010 at 10:55 AM, Raj Kumar wrote:
> Hi Dear,
>
> There is a problem in excel so kinly solve my querry
>
>
Dear All
In attach sheet i want to use if condition based on two cell value, how to
write IF formula
using OR, AND. i will greatly appreciate any help on this.
Thank You
--~--~-~--~~~---~--~~
-
Can anyone provide me the formula for below query.
Report Date Total Logged Time at Work Hrs 7/2/2009 8.86 7/2/2009 9.03
7/2/2009 7.92 7/2/2009 9.02 7/3/2009 9.05
Answer should be 26.91. Excluding the value less than 8.00 hrs and it should
calculate only for one day(7/2/2009).
I have tried i
Hi All,
Can anyone provide me the formulas as per the requirement in the attachment.
Rgds,
Putta - Bangalore
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and
35 matches
Mail list logo
