NESTED IF STATEMENTS #2
Having a little problem in an excel class, hoping someone might be
able to help. I'm trying to fill in the discount column on a
spreadsheet with the following info. The problem states use a nested
form of the IF function to calculate 15% if Amount is greater that
$300., 10% if Amount is greater than $100., and 0% if Amount is less
than $100. The Amount column is cell D5. Anyone know how to write the
formula and explain how to go about it? Any help would be much
Let's see. This is homework so you should come up with the answer yourself.
Did you start by looking in the he...Multiple PST Files #2
I am running Outlook 2003 and would like to have Outlook use two
different .pst files (one for my work stuff and one for home) on the
same computer. Is it possible to do this?
If so, can I can I configure one of the pst files to get e-mail from
one account, while the other pst file is configured to get mail from
the other account?
Yes, you can create multiple PSTs. I keep mine stored in
the same file location but with different names.
Depending on which version of Outlook you run, you can
creat a new pst from file/new/Outlook Data File (I run
Outlook 2003 but had multiple P...lost menu bar #2
HELP!!! The main menu bar is missing off my excel sheet
and I can't seem to find anyone to help me get it back.
The menu I am missing is the one that includes - File,
Edit, Insert and etc. I have tried...right clicking -
customize - toolbars, but I don't seem to have the needed
item. Anyone with suggestions - please reply...
if you right-click on the menu bar you should see an item like
'General'. Check this item
JoEllen OSBDC wrote:
> HELP!!! The main menu bar is missing off my excel sheet
> and I can't s...How refresh imported data automatically?
In Excel, I've imported data into a worksheet. I know I can click Data..
Refresh Data to requery the source, but I want to be able to do it in a more
Is there some sort of macro I can write when opened or something?
Select the cell the data starts in, select Data/Import External Data/Data
Check the box "Refresh on file open" and anything else that needs checking
Other than that, you could record a new Macro that selects your cell,
refreshes data, and assign the macro to a keystroke, or even an icon.
...Thread Synchronization #2
I have a shared resource, say a file which is to be accessed between
threads. There are say 20 Read threads and 1 Write thread. When the Write
thread is writing into the file, the Read threads should be blocked, and
1 read thread reads, the Write thread should be blocked. The Read threads
read simultaneously, but only say 5 at a time. What kind of synchronization
mechanism can I use for this?
You can create a mutex a adquire it when a read operation start, check it
before start any write operation.
You will need another mutex ...Unicode "private use" glyphs in Powerpoint and Word 2008 #2
Office 188.8.131.52 on Leopard 10.5.2, all updates applied to both.
A friend is migrating from Windows to Mac, and has come across
something that we're trying to work around.
He has some .ppt files with font glyphs in from a Unicode .ttf font (a
specific purpose font for showing the LCD display characters on a
piece of monitoring equipment). When we bring the font and .ppt over
to the Mac, the glyphs from the normal ASCII range come over into
Powerpoint 2008 fine, but the glyphs from the "private use" range from
F000 upwards a way don't transfer. In Powerpoint they show as spac...using dates Part 2
Karl was great in helping me get to this point with dates, now I'm wondering
if we can take it 1 step further?
For Activity Dates prior to 2/1/2007 they are using a normal reporting year
and the formulas below take care of Activity dates >2/1/2007?
So for example prior to 2/1/2007
1/1/2006 would have a B_Qtr of 2006-1
1) B_Qtr - 2011-1 --- Format(DateAdd("m",11,[ActivityDate]), "yyyy - q")
2) Year - 2011 ---- Year(DateAdd("m",11,[ActivityDate]))
3) Qtr - Q1 ---- Format(DateAdd("m",11,[ActivityDate]), "q")
Than...Send 1 address to 2 mailboxes
I want to create an address and have any mail sent to that address delivered
to two separate users' mailboxes. How can I do that.
I've tried simply adding the address in the two users' "Email Addresses" tab
in the User's properties of ADU&C. But it wouldn't allow me to add the same
address to the second user ("This email address already exists in this
I've also tried creating a new user for the address and forwarding the email
to the 2 other users (Exchange General tab - Delivery Options button -
Forward To field). But ...New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet
via a macro, a new named range (for the same range) is created. This
does not pose a problem, but after a while, I'll have a huge number of
named ranges that will never be used. Why does Excel name the range
and how can I stop this? I noticed in the recorded macro, there was a
line .Name = "drd_5". I commented this out to see what would happen,
but it just renamed the range "ExternalData_5". The next one was
You could refresh with differen...Publisher 2000? #2
Is there a place where I can still get version 2000? I've been looking, but
all I can find are updates and the 2007 trial. My computer can't run 2007.
*If* if can be had, try something like eBay. (I wouldn't buy software that
way but that's just my preference.) You may find you have better luck
finding a leftover copy of Pub 2003 from some online retailers. (I actually
prefer that over 2000.)
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Jason" <Jason@discussions.microsoft.com> wrote in me...Compare 2 different workbooks with the result in a 3rd
I have two workbooks (2005 Sales, 2004 Sales), which track daily results in
half hour intervals. I want to be able to show the increase in 2005 in a 3rd
workbooks. The first two workbooks are identically formatted. How can I do
this? Many thanks to all in the forum who have helped in the past.
If the data is in exactly the same position in the two worksheets you could
copy/paste one's data to a new worksheet and then copy the second's, doing
an Edit, Paste Special, Subtract on top of the first's data. This is
admittedly crude but it is easy to do.
&q...import from eudora #2
I have used Eudora for many years, but am planning to set up my email in
outlook. I want to move all of my mailboxes to outlook. Eudora does not
have an export function. Do I need to go through something else, such as
Thunderbird. I can't use Outlook Express, because it only imports through
Eudora v3.0. I have 4.3.
Any thoughts on this?
"Nate Rosenthal" <firstname.lastname@example.org> wrote in message
>I have used Eudora for many years, but am planning to set up my email in
>outlook. I want to move all of my m...IMPORTING MONEY FILES DUP ENTRIES
I have been unable to run money98 files in money2003.Tried
importing files but all tranfers between accounts are
duplicated. Don't understand how to import all the
accounts at once. I created new accounts in 2003 and
imported one by one, but any transactions between accounts
Follow the prompts on the import file dialog that tell you to select
multiple files to import at the same time. There are other guidelines if
investment accounts are involved. You might want to review postings on this
subject in the group archives at http://groups.google.com.
"JAYNE" &l...Importing into Access 2000
I have a text file 13187 characters long. It will not
import or link. Any suggestions?
Suggestions? First one is to give us a bit more information:
What happens when you try?
Can you import other text files?
What's different about this one?
Separated or delimited?
How many fields?
Where did it originate?
On Fri, 7 Nov 2003 14:57:16 -0800, "William Madison"
>I have a text file 13187 characters long. It will not
>import or link. Any suggestions?
John Nurick [Microsoft Access MVP]
Please respond in th...Importing Purchase orders with integration manager.
When I import a purchase order in Excel, GP creates a
separate po for each line item. How do I get the line
items under one PO number? I notice that the SQL option
does not allow you to have a query relationship.
You will need two source tables, one with PO header info and one with line
information. Use two sources in Integration Manager and relate them by a
common field (like PO Number)
If I remember correctly, there is a sample integration provided just like
Richard L. Whaley
Author / Consultant / MVP
Documentation for Software Users
For help learning and better using Dyna...Excel AutoSave #2
In Excel 2000 was this feature available?
User is not seeing it.
Excel 2000 had the AUTOSAVE.XLA Add-in
Should be in Tools>Add-ins.
If not available there, do a file search on your computer.
If not there, install from the CD.
Gord Dibben Excel MVP
On Thu, 6 May 2004 13:26:16 -0700, "Ssolano"
>In Excel 2000 was this feature available?
>User is not seeing it.
...Import excel named range into Access error 3011
Hi, I've read a few posts on this topic, but none addresses my
I use Office 2003 on an XP SP3 machine.
I am using transferspreadsheet to import a named range in an excel file
This has worked beautifully until suddenly it stopped working.
I find now that if I extract the address of the named range from within
the Access VBA code,
it looks like this:
rather than this, which is what it should be:
When I open the spreadsheet and get the address of the named range in
the immediate window,
it also has the #REF error....downloading #2
I have attempted to download bank statements into Money
2001. Although my bank shows the statements were
downloaded, nothing appears in Money,and I am not offered
any opportunity to review or add the transactions.
Does anyone have any advice.
I am familiar with how it is supposed to work, for I had
downloaded statements successfully in the past.
...Missing send/receive button #2
After I installed Outlook 2003 on a new computer and migrated my data file,
there's no send/receive button when I click on personal folders in Mail and
it doesn't appear on the tools menu. I've done reinstall/repair twice
without fixing the problem.
Is there some configuration procedure I need to do? Thanks for any help.
> After I installed Outlook 2003 on a new computer and migrated my data
> file, there's no send/receive button when I click on personal folders in
> Mail and
> it doesn't appear on the tools menu. I've done reinst...Syncronizing Outlook Contacts with Quick Books Pro #2
I am unable to get "home" addresses in Outlook Contacts
to show up in Quick Books Pro. Only the "business"
addresses show up. HELP!!!!
which version of outlook and did it ever sync all the addresses?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Search for answers: http://groups.google.com
Most recent posts to the Outlook newsgroups:
"Curtis&qu...playing sounds in email #2
I wonder if anyone can please help me to know how to send an email which
will automatically play a sound file when it is previewed or opened by the
I have received such emails occasionally, and I now have a serious reason
(as opposed to a 'fun' one, which is what all these others were!) to want to
...Bulk Import Limitations ?
Besides the obvious. Are there some undocumented/unwanted limitations to the
Have 125 additions to the UI that range from bit, picklist, date, text, etc.
Unable to import data for these all at once via tab txt. Always get “invalid
However I can import each type at a time.
Ex. All bit, date & text only fly through no problems but together with pick
list, it fails.
But I can import the pick lists if the bit data is left out.
This only occurs when I map the values. The match perfectly, case, format,
Any ideas appreciated; beside go with Scr...CColorDialog #2
I am trying to work with the CColorDialog in an MFC app and everything is
going fine, except I would like to change the title of the dialog so that
instead of "Color" I make it say what I want it to say. Seemed easy enough
to do, but no. Not much info on the web unless I am searching for the wrong
kinds of info.
Of course, it derives from CWnd, so I tried SetWindowText(), but that failed
and I assume it is because the handle to the color dialog doesnt exist until
you call DoModal(). Thus the call to setting the window text fails because
there is no window.
So, what are th...Up-side down Graph #2
How do I make an Up-side down graph. (with y-axis values shown on the
Double click the axis and on the scale tab check Values in reverse
order. Is that the upside down you want?
> How do I make an Up-side down graph. (with y-axis values shown on the
> opposite direction).
Andy Pope, Microsoft MVP - Excel
Thanks for the solution. its been a great help.
Andy Pope wrote:
> Double click the axis and on the scale tab ...Installation CRM 1.2 on SBS2003 SP1 fails, please help
At the end of my installation I get an error windows with;
Setup was unable to install Microsoft CRM Server
Setup was unable to provision your organisation
Setup was unable to create user settings.
Access is denied.
Active Directory is in native mode
I am installing as the administrator (domain admin)
security account for services in Local System account
Local System account and computer are added to the Pre Windows 2000 comp group
Thanks in advance for any support
Did you enter your organization name precisely the same way it appears on
your CRM 1.2 licenses?