Hello group,
there is other way to translate.
Anil
--
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
quick attention or may
Hi Group,
In the attached excel sheet the maturity value is working fine for years
and months however it not giving me the exact result when it come to days
option.
Would you request to have look into this and provide appropriate solution.
Regards
Santosh
santoshkumar.subu...@gmail.com
--
How to make use of this (Command Button Text Box), as I want to insert
the values in no's for identification of the employee.
note: my explanation here add some more information for u r convenience
what I mean is - the values entered in text box should reach the the
Col A everyrow one by
Hello Excel community.
I created the sub UsedShortCutKey to run when I open a workbook. This
sub was made to call the sub MainProcedure (strLetter as string) when
someone presses Ctrl+Shift+a. But when someone presses these keys, it
doesn’t happen. Instead, Excel warns saying:
You can not run
, 2012 at 10:16 AM, xlstime xlst...@gmail.com wrote:
or try this one.. for any format
=TEXT(B2,-00-00)+0
On Sat, Jan 21, 2012 at 10:14 AM, xlstime xlst...@gmail.com wrote:
Hi Ashish,
use this formula (if you date format is same 20120121 )
*=DATEVALUE(CONCATENATE(LEFT(B2,4),-,MID(B2,5,2
Dear Amit,
In this formula we are searching unique value of two columns
Red Color part is 1st criteria
Green Color part is 2nd Criteria
=IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))1,Duplicate,Unique)
we can also use..
=IF(COUNTIFS($A$2:A2,A2,$B$2:B2,B2)1,Duplicate,Unique)
--
Thanks
Private Sub CommandButton1_Click()
Dim lngDays As Long, lngActualDays As Long
On Error Resume Next
lngDays = Day(DateSerial(Year(TextBox2.Value),
Month(TextBox2.Value) + 1, 0))
lngActualDays = lngDays - Day(DateSerial(Year(TextBox2.Value),
Month(TextBox2.Value),
=IFERROR(ROUND(F5*(1+((F6/100)/C9))^(C9*IF(E7=Months,(F7/12),IF(E7=Years,F7,F7/365))),2),)
Regards,
Sam Mathai Chacko
On Sat, Jan 21, 2012 at 5:25 PM, santosh subudhi
santoshkumar.subu...@gmail.com wrote:
Hi Group,
In the attached excel sheet the maturity value is working fine for years and
Private Sub CommandButton1_Click()
Me.Cells(Rows.Count, 1).End(xlUp)(2).Value = Me.TextBox1.Text
End Sub
On Sat, Jan 21, 2012 at 7:17 PM, Mohammed Muneer mmun...@ccc.com.qa wrote:
How to make use of this (Command Button Text Box), as I want to insert the
values in no's for identification
Hi,
Santhosh very very thanx for the help!
Good Keep it up!
Regards,
Muneer,
CC...
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of santosh subudhi
Sent: Saturday, January 21, 2012 11:10 PM
To:
Hi sam,
Can you post in Excel 2003 ? ..I am using excel 2003
Regards
Nikhil Shah
On Sat, Jan 21, 2012 at 10:56 PM, Sam Mathai Chacko samde...@gmail.comwrote:
=IFERROR(ROUND(F5*(1+((F6/100)/C9))^(C9*IF(E7=Months,(F7/12),IF(E7=Years,F7,F7/365))),2),)
Regards,
Sam Mathai Chacko
On Sat,
for excel 2003
=IF(ISERROR((ROUND(F5*(1+((F6/100)/C9))^(C9*IF(E7=Months,(F7/12),IF(E7=Years,F7,F7/365))),2))),,(ROUND(F5*(1+((F6/100)/C9))^(C9*IF(E7=Months,(F7/12),IF(E7=Years,F7,F7/365))),2)))
On Sun, Jan 22, 2012 at 10:37 AM, Nikhil Shah nikhil201...@gmail.comwrote:
Hi sam,
Can you post
12 matches
Mail list logo