Function help needed urgently!!! #2
Hi anyone who can help...
I have two sets of figures 1 is sales and 1 is target.
Sales Target Incentive
In the Incentive column I want a formula that will
calculate the Incentive payment for employees who exceed
there target. The easy part is the if statement for
example 10% of their sales if they exceed target:
The complicated part comes in to play when only when they
hit multiples of 10 are they entitled to an incentive:
If the Sales are 5 and the Target is 5 - no incentive.
If the Sales are 10 and the Target is 5 - no incenti...An advanced filtering issue #2
Any way to use the advanced filter in order to get the needed result as
A14:F15 ? in order to show all the values of each month for the date
30-09-2005 . (please check attached sheet)
Any other suggestion ?
Thank you very much .
|Filename: question abt advanced filtering.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3874 |
----------------------------------------------------------...Reason Code Report #2
I sell a perishable product, therefore I need to be able to track product
that has perished. In the help menu, under reason codes, it states, the
information is stored for use in tracking and reporting. That is why I chose
this method to record dead plants. Now I need to know the cost and profit
lost of these dead plants, as well, I don't want to purchase them again. So
how do I get the information???? I read about a guy tracking dead fish by
making the item inactive, although he was having trouble, should I change
how I track this info for the future? I would greatly appreciate h...running macros #2
I have created a macro that imports data, sorts it, and delimits it. The
macro in itself works just fine, however trying to run it a second time on a
different file causes it to blow up.
Prior to importing the data, I clear out the old contents so it doesn't
prompt me to overwrite, the re-run of the macro WILL prompt me, and rather
than overwrite, it appears to insert instead, and therby causes it to trash
the existing data.
I'd sure appreciate any help here. Thx.
Without seeing your code, it's nearly impossible to tell.
In article <58725910-CF96-4589-8CF0-76ADF515E2...Charging 1 or 2 Taxes on items automatically
I have 4 columns, A1-item, B1-tax, C1-tax, D1- Total. Some items are taxable
on both, others only on 1, is there a way to automatically charge 1 or 2
taxes on the total.
It is easy:
set the values in columns B and C as percents. Then D would have something
With this set-up you can remove a column B or C tax just by setting the
value to zero.
> I have 4 columns, A1-item, B1-tax, C1-tax, D1- Total. Some items are taxable
> on both, others only on 1, is there a way to automatically charge 1 or 2
&...XP Style button using MFC 4.2
I am using Visual C++ 6, MFC 4.2. Windows XP SP2.
My problem is, how could I get the XP Style buttons on the dialog. If i
dynamically create the button using CreateWindow() the button still looks
I've tried 'Button Controls' article on MSDN but no luck.
Could anyone help me?
Themes are handled by the system, and not on a button-basis.
The way to give your application running on XP the themed look is to include
a manifest resource. The resource can either be a resource compiled into
your EXE or it can be a separate file in the same directory as your ...CRM v1.2 Report Manager Problem
I am having a problem with Report Manager after having reinstalled the
MS CRM on the CRM Server. When I logged in using Report Manager, it
stated that the "CRM folder does not exist!" I can run all other CRM
services fine but with this error I cannot publish all of my reports
and hence keep getting the Crystal Report Logon Error.
I am stuck to this problem for so long and still have no solution to
it... I tried to delete and rebuild the APS database, uninstalled CRM
then go into the registry to delete all crystal related values,
everything I can digged out from the internet...Non3rd Party: Multiple Taxes (i.e. 2 Diff States)
I posted this a few days ago, and had some great response, however, I am
looking for a non 3rd party solution to this issue. Does anyone have any
I am trying to establish two different Item tax structures for two different
tax authorities, let's say one for MN and one for ND state.
Preface: I am giving this as a real HL example. Assigning taxes on a per
customer basis will not work as a solution to this issue. Please do not take
it literally that I need to assign per customer based on Billing or Shipping
MN Tax has: MN State, MN City and MN C...Outlok 2003 Word Attachments are Read Only and in 2 page view
I have a client with Outlook 2003 and when he receives an email with a word
doc attached and attempts to open it (rather than save it 1st) it opens in
Word as read only and shows as a split screen (2 page book view). if he
saves it to the drive 1st he can remove the read only attribute and then
Word opens it normally.
Not sure why the view is different. My OT advice - always save attachments
you want to edit, and then open them. Otherwise you're using a temp copy of
the file & may lose changes.
Marc Seidler wrote:
> I have a client with Outlook 2003 and when he recei...Design checker question #2
I often get an "error" in design checker that says "Object is not
visible." When I right-click and choose "Go to this item", nothing
apparent happens. When I choose "Fix: bring object to front", nothing
happens, and the error message does not go away.
What am I missing here?
Select all, give everything a line. Does the phantom object show up? If it does,
make a note where it is and do an "undo." At least you will know the area where
to try to delete the object.
"Craig Schiller" &l...Outlook backups #2
I am trying to find out some information about outlook backups. I was
under the impression that with Outlook 2003 you no longer have to close
down outlook to do the backup. But I was just told by a friend that
that is not true the .pst files are locked and you still can't back up
no matter what software you use unless outlook is closed. Does anyone
know of software that will backup outlook even if it is opened or
possibly will close outlook before it backs it up?
There are 3rd party utilities that do this. But Microsoft produced a little
addon to for personal folder ...time calculation 08-14-07
Any Help Please. . .
I am new in access, and im doing some calculations from my query design. I
need to calculate two fields in a query. It is like cascading calculation
that the new field is the result and that result will be added to 2nd and to
3rd row and so on. The calculation is on hh:mm in 24 hr format. please see
OnChk OffChk On/OffDifference Total Hour
8:59 13:45 4:46 1110:57 => This is carry over figure
8:50 12:57 4:07 1115:04
7:48 9:49 2:01 1117:05
1. I got the On/OffDifference by us...Deposit on Back Order #2
Hi , how can a take a deposit from a customer on MS Point of Sales
You can't, MSPOS doesn't support backorders, layaways, work orders, or
quotes like RMS does.
Here's a chart of the major differences between products;
Get Secure! - www.microsoft.com/security
You must be using Outlook Express or some other type of newsgroup reader to
see and download the file attachment. If you are not using a reader, follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on ...Check links #2
I get this error message when I do a check links in Bank Managment
Amount does not match with CB_Distribution
FYI we just Upgraded from GP9 to GP10 sp3
...Visual Basic Error Message #2
After updating an application unrelated to Excel that I have been using for
two years, evefry time I now start Excel (I'm using Excel 2003, by the way),
I initially get a Microsoft Visual Basic error window popping up on my
screen: "System Error &H8000FFFF (-2147418113). Catastrophic failure." When
I click OK, a second Microsoft Visual Basic error window pops up: "Out of
memory." I then click OK, the window disapears, and then everything runs
just fine. All my calculations, prior work and spreadsheets and so forth, as
well as new files I create are readily...OWA Question #2
I'm running Exchange 2003 with IIS 6. Is there a less graphical version or
option for people that have a dial up connection?
Yes. You can use the basic version per the following:
821909 Use Exchange Server 2003 Outlook Web Access Basic with Browsers
And this should help you with setting it up:
830827 How to manage Outlook Web Access features in Exchange Server 2003
Please do not send e-mail directly to this alias. This alias is for
newsgroup purposes only.
This posting i...Count function #2
I have in Several Columns a list of Customer Names and for each column I
would like to do a Count of how many in each column but when I do
it returns a 0 and should return 4
Does a Count not work on text?
if this helps please click yes, thanks
> I have in Several Columns a list of Customer Names and for each column I
> would like to do a Count of how many in each column but when I do
> it returns a 0 and should return 4
> Does a Count not work on text?
> Tha...Outlook 2003 not closing #2
When I'm done reading and sending mail I close Outlook (It's version 2003,
running under Windows XP) using the 'Close' button. After going through a
day of opening, checking and answering mail and then closing when done,
I've noticed that Task Manager shows multiple copies of OUTLOOK.EXE
running. None of them seem to be taking CPU resources, but they do have
memory assigned. During the day, I don't notice any error messages.
Everything seems to be working fine. There are no clues to indicate that
something hasn't closed until I try to re-boot the PC. Th...USING DATES IN FORMULAS #2
I foubd a problem with excel 2003
If you introduce a formula using dates (in spanish version) (dd/mm/yy),
excel doesnt makes the calculation........... ???? Can somebody hep me
In the USA version (English), I could use:
=if(a1=date(2005,10,27),"It's Oct 27, 2005","it's not")
to refer to a date.
I don't know what the Spanish function is for =date(), though.
Carlos Benavides wrote:
> I foubd a problem with excel 2003
> If you introduce a formula using dates (in spanish version) (dd/mm/yy),
> excel doesnt makes the calculation........... ????...How do I use a pivot table to get an average count? #2
I have a list of transactions with colum headers of Month, Date, Weekday,
Time and the transaction data. I would like to see the average number of
transaction per hour per day. Can this be done in a pivot table?
...Migrating Public Folders #2
I have just got involved in a Migration from EX5.5 to EX2003.
1. AD is clean an all accounts have been manually created not migrated.
2. Company has over 12,000 public folders on EX5.5.
3. I need to migrate mailboxes to EX2003 and connect then to the manually
4. Migrate the Public Folders whilst keeping the security.!
What is the best method to do this.
All migrition tools seem to use sid history etc, obviuosly not an
I have looked at a util called PFADMIN. Does this export security using
display name. If so could this be used to re-assign security on the EX2003....slow performance #2
help! i can't seem to get my outlook to scroll through
messages quicker. when i scroll to the next message, it
takes up to 10 seconds to bring up the next one! it's
driving my nuts! anyone have suggestions?
What version of Outlook? What kind of system do you have?
Ben M. Schorr, OneNote-MVP
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
"firstname.lastname@example.org" <email@example.com> wrote in
mess...first tab to other tabs #2
i want to enter data in the first tab, without retyping them in individual
tabs have the automatic sepeared in other tabs.
a b c a b c
a b c
global 300 pcs 10 boxes global 300 pcs 10 boxes island 400
pcs 20 boxes
island 400 pcs 20 boxes global 200 pcs 5 boxes island 300
pcs 10 boxes
island 300 pcs 10 boxes
global 200 pcs 5 boxes
all vendors global
...Retrieve data #2
I have a spreadsheet "franchise Stores" containing franchises in column "a"
and their stores store# in column "b", a simple database with most franchises
having more than one store. Every day different stores submit their problems
to us using only their store numbers. I have a seperate spreadsheet for these
calls "call log". I manually look up the stores franchise with the store
number using the Find Function in "franchise Stores", and copy, paste it to
"call log". Is there a way to have excel do this on its own? There are too
many to...Open XML File Converter
Operating System: Mac OS X 10.6 (Snow Leopard)
Any word on an update to this converter that resolves the "There is not enough memory or disk space to convert this document" bug on SL? I've seen it reported elsewhere so I'm assuming it's a known issue, but can't find any relevant info here.
On 11/2/09 2:33 PM, in article firstname.lastname@example.orgR9absDaxw,
"email@example.com" <firstname.lastname@example.org> wrote:
> Any word on an update to this converter that resolves the "There is not e...