Hi Norman,
This should be possible with a solver/scenario manager.
Could you please attach a file of Sample data, so that it is easy for us to
give you a relevant solution.
Regards,
Andy
On Sat, Aug 22, 2009 at 10:38 AM, Norman May wrote:
> Michael,
>
> I'm not sure if this is what you want:
>
Michael,
I'm not sure if this is what you want:
51556 is the number that calculates $500
=IF(A11>51556,500,IF(A11<=6000,IF(A11<0,#VALUE!,ROUND(A11*0.012,2)),72+ROUND((A11-6000)*0.009+18,2)))
Norman
On Fri, Aug 21, 2009 at 4:36 PM, Michael484 wrote:
>
> I am trying to set up a formula to cal
I am trying to set up a formula to calculate the discount for sales
tax filing.
The allowable discount for timely filing and paying is 1.2 percent of
the first $6,000 collected and 0.9 percent for the amount above
$6,000.
The discount is capped at $500 for each return.
The formula for the disco
Just something I wanted to share because I was excited about it!
Using the code: ActiveWorkbook.FollowHyperlink Address:="http://
www.cnn.com"
One can avoid importing object libraries and using shells and such to
open external programs through Excel (Or any Office program using VBA,
I would assu
- Original Message -
From: Sandeep
To: excel-macros@googlegroups.com
Sent: Friday, August 21, 2009 5:53 PM
Subject: Re: $$Excel-Macros$$ Re: Need Urgent help in finding formula.
Hi Dave
Please you tell me what is the purpose of -- in your sumproduct formula and
what are the ways to
When I bring up the Forms toolbar there are some controls that are
grayed out, specifically the Dropdown List and some others. Can anyone
shed any light on this. I am trying to construct a form and the
Dropdown List control would be needed. Any help would be greatly
appreciated.
Tommy
--~--~
Hi Team,
I wrote piece of code to generate Dropdown Menu and call various Macros from
it.
This piece of code makes Menu permanent. My requirement is when User open
specific WorkBook and in specific Workbook a Specific Sheet, then only
custom Dropdown menu should appear.
Any help on this will be h
I have a cell A1 in which I enter a number value everyday. I was
hoping some type of function or form in differet cell B1 so each time
A1 is updated it add up previous A1 value and show the cumulative.
Example:
this is the way I want B1 to add previous values when I enter value in
A1 manually eac
Hi Wes,
Attached herewith is the solution with explanation. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Aug 4, 2009 at 6:41 AM, Wes wrote:
>
> I've been trying to get some cell validation
Dear Shah
For a best solution you have to share a demo file with us.The file should
have all of required possible data combinations and their conditions.
Then i can try to give you an easy and best solution.
Sandeep
- Original Message -
From: "Shah"
To: "MS EXCEL AND VBA MACROS"
Se
Hi Vinod,
Your data is not clear. Are you talking about the sorting to be done on
text enteries in column C, if so then is there any relation with the numbers
in column D, OR are you taking Glass/Tiles/Bricks as the order of sorting
like Big-Bigger-Biggest. Please explain? Thanks
--
DILIP KUM
Hi Dave,
You are a STAR!!!. I really appreciate your efforts. Thank you very much.
Best regards,
Vinod
On Fri, Aug 21, 2009 at 4:11 PM, Dave Bonallack
wrote:
> Hi Vinod,
> Have a look at the attached.
> I have had to use a helper column to extract the "Bricks, Tiles, Glass"
> info
> Then u
I have developed an Add-ins for Excel that worked fine in Office 2003
but not work in Office 2007. The specific problem being that it has
functionality invoked by toolbar buttons. In office 2003 the toolbar
is loaded by code in the Add-in but of course office 2007 has the
ribbon instead. No toolba
I want to make a "Project Menu" or "Pick List" in Excel.
- There will be a long list of "Items"
- Each "Item" will have a number of choices
- The user can pick one choice per item
- Each choice will add or deduct a cost from the project and impact
the schedule...
- We will be showing the "impact"
Hi Dave
Please you tell me what is the purpose of -- in your sumproduct formula and
what are the ways to use it. And is there any other operators which are not
commonly known.
Thanks
Sandeep
- Original Message -
From: Dave Bonallack
To: excel-macros@googlegroups.com
Sent: Fri
Hi Vinod,
Have a look at the attached.
I have had to use a helper column to extract the "Bricks, Tiles, Glass" info
Then used that to rank the data.
Hope this helps.
Regards - Dave.
Date: Fri, 21 Aug 2009 13:09:40 +0530
Subject: $$Excel-Macros$$ Need Urgent help in finding formula.
From: vinod.ma
Thanks Sandeep.
But in my case I have a monthly scedule hence there are around 32
payments coming in for each product
isnt there an easier way of doing this?
On Aug 21, 1:30 pm, "Sandeep" wrote:
> find the attached file for your desired solution
>
> Sandeep
>
>
>
> - Original Message -
Another solution
Date: Thu, 20 Aug 2009 17:18:15 +0530
Subject: $$Excel-Macros$$ required support.
From: gi6...@gmail.com
To: excel-macros@googlegroups.com
Team,
I required support from all of U.
I required some formula which can calculate details of tracking from last
appear.
Pls refer
Hi Team,
Not in this way. :(
First i do not want to sort.
Second the ranking should be based on Glass and should not consider the city
or district.
Example
Glass- Based on bigest value it should rank (1,2,3)
Bricks- Based on bigest value it should rank (1,2,3)
Tiles - Based on bigest value it sh
Attached is a solution may be helpful for you.
Date: Thu, 20 Aug 2009 17:18:15 +0530
Subject: $$Excel-Macros$$ required support.
From: gi6...@gmail.com
To: excel-macros@googlegroups.com
Team,
I required support from all of U.
I required some formula which can calculate details of trac
Hello Team,
I have attached file in which i need a formula in the column E, instead of
the manual ranking in need a formula based on the item mentioned in the
column C.
Please make a note, ranking is based on the largest value to the particular
item in C. ie Glass/Tiles/Bricks
Kindly assist asap.
- Original Message -
From: "Sandeep"
To:
Sent: Sunday, August 16, 2009 9:55 AM
Subject: Re: $$Excel-Macros$$ Re: replace when large data in cell
> Hi,
>
>I have to replace ! in the workbook, you can use what ever you want in
> place of !. But the find and replace did not work fo
Hi,
I am trying to calculate the number of payments that a customer shall
have to make when purchasing certain realestate products.
Reposting to preserve formats above:
**
Assumptions:
#Units being sold:
Years 1 2 3 4 5
Product 1 581012
- Original Message -
From: "Sandeep"
To:
Sent: Thursday, August 20, 2009 5:53 PM
Subject: Re: $$Excel-Macros$$ need a good method to count next 5 months
> Hi Osiso
>
> Below is some code which prints all the month form 1997 to 2009 in
> 199701,199702 format with a single loop.
> To
- Original Message -
From: Sandeep
To: excel-macros@googlegroups.com
Sent: Friday, August 21, 2009 8:42 AM
Subject: Re: $$Excel-Macros$$ Re: Using IF, AND, OR Function in Single formula
Please find the attach file with all of you need
Sandeep
- Original Message -
From: Sw
find the attached file for your desired solution
Sandeep
- Original Message -
From: "Shah"
To: "MS EXCEL AND VBA MACROS"
Sent: Friday, August 21, 2009 11:24 AM
Subject: $$Excel-Macros$$ Rolling Payments Calculation
Hi,
I am trying to calculate the number of payments that a customer
26 matches
Mail list logo
