Thanks *Paul & Sam*, your formula is working fine.
Regards,
Kuldeep Singh
On Tue, Apr 16, 2013 at 11:23 PM, Sam Mathai Chacko wrote:
> Since you've ruled out 5 and 10, I would've thought =MROUND(C1+5/2,5)
> should be fine
>
> Regards,
> Sam Mathai Chacko
>
>
> On Tue, Apr 16, 2013 at 8:46 PM, Pr
For the sake of you opening up your options for a response, why don't you
tell us why you want to open the access database using code?
On Mon, Apr 15, 2013 at 6:01 PM, wrote:
> Hi all,
>
> I am stuck, hope someone can help me...
>
> I a using the following code in Excel, to open an Access datab
Since you've ruled out 5 and 10, I would've thought =MROUND(C1+5/2,5)
should be fine
Regards,
Sam Mathai Chacko
On Tue, Apr 16, 2013 at 8:46 PM, Priti_verma wrote:
> Hi Kuldeep
>
> I think this formula fullfil your requirement.
>
> =ROUNDUP((A2*2)/10,0)*10/2
>
> Regards
>
> Pr
Hi Kuldeep
I think this formula fullfil your requirement.
=ROUNDUP((A2*2)/10,0)*10/2
Regards
Priti verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kuldeep Singh
Sent: 16 April 2013 8:17
To: excel-macros@googlegroups.com; excelvbacli...@googleg
What's not working?
I placed this formula in your worksheet, copied it down,
and the results exactly matched what you listed as expected results.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
Thanks paul but it's not working.
On Tue, Apr 16, 2013 at 8:32 PM, Paul Schreiner wrote:
> Here's what I would do:
> since you're wanting to round to 5 or 10's,
> I'd multiply the number by 2, then you're technically rounding by 10's or
> 20's,
> which, is the same as rounding by 10's.
>
> Then,
Here's what I would do:
since you're wanting to round to 5 or 10's,
I'd multiply the number by 2, then you're technically rounding by 10's or 20's,
which, is the same as rounding by 10's.
Then, divide the number by 10 (which moves the decimal point)
and round the number to an even integer.
By mu
Hi Experts,
I want to roundup formula but according to my requirement. requirement is
attached
*If value is digit 2,3,4 output 5 Other value is digit 6,7,8,9 output 10*
Thanks in Advance.
Regards,
Kuldeep Singh
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It
You didn't mention what error you're getting, or where the error occurs.
I tested it and I think I found it:
Let's take a look at how Excel operates:
If you didn't have an "Event" macro, when you double-click a cell,
what normally happens?
If you still have the default "edit in cell" option avai
Hi team,
Awaiting ur valuable response on my below email.
Regards,
Kaushik Savla
-- Forwarded message --
From: "KAUSHIK SAVLA"
Date: Apr 15, 2013 8:21 PM
Subject: Fwd: $$Excel-Macros$$ Time Tracking Tracker
To:
Hi All,
I am getting error message when I am trying to apply the b
thx
On Monday, April 15, 2013 9:58:30 AM UTC+2, colmkav wrote:
> Hi,
>
> I am trying to set the formula of a cell to be the following: =D6 &
> YEAR(MonthEndDate) & "." & MONTH(MonthEndDate) & "." & "\Outputs\"
>
> However the following code gives this forumula instead: = 'D6' &
> YEAR(Mo
--
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, Ne
Hello Ashish,
We are using MS office 2007.
I have attached sample sheet.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
From: koul.ash...@gmail.com
Date: Mon, 15 Apr 2013 20:14:02 +0530
Subject: Re: $$Excel-Macros$$ print current file to pdf
To: excel-macros@goo
Dear Lalit
Thats amazing,Perfect,mind blowing.Which I want I got it.Brother thank very
much. you are great.
Also Thanks others members like Chaya,Priti,Anil who struggle for my
solution.
Once agian Thanks very much all.
Regards
Amar
On Tue, Apr 16, 2013 at 12:52 PM, Lalit Mohan Pand
Hi Noorain,
Can you please share all stuff for get. function
.
Enjoy
Team XLS
On Thu, Apr 11, 2013 at 5:45 PM, NOORAIN ANSARI wrote:
> Dear LK,
>
> Please try it..
>
> =GET.CELL(63,INDIRECT("RC[-1]",))
>
>
>
>
> On Thu, Apr 11, 2013 at 4:48 PM, L.K. Modi wrote:
>
>>
Follow steps and try this. Hope this will work for you:
1. *Right Click on Cell C5*
2. *Create a hyperlink with cell refrence C5 in the same (output sheet )*
3. *Do same for Cell D5 and create hyperlink with cell refrence D5 in
the same (output sheet )*
4. *Right click on output sh
16 matches
Mail list logo
