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
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
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
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
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 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
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
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,
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
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
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
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
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
--
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
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
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
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:
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
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
*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
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
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
>
>
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
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
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
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
=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
,-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
>
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
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
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
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
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
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 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
--~--~-~--~~~---~--~~
-
35 matches
Mail list logo