Excel 97 quote calculations #2
You could try extending the IF statement. I don't know whether it will work
in Excel 97 as I have only used Excel 2000, but here it is:
and so on.
Hope it works.
No basic worksheet functions have been added in recent versions, your
approach would work even in Excel 4 (and probably earlier). However,
you can have only 7 levels of nested functions in any version. A
VLOOKUP table would be much more flexible in terms of the number of
rates you could choose among.
Satyajit Bhagwat wrote:
> Hi Jackie!
I've moved to a new pc and for some reason I thought that when you
backed up, a new file was created. Am I right? At the moment, it's
just backing up to the backup file. So I've just just my working file
and my backup file. Please could you clarify this?
In microsoft.public.money, abc wrote:
>I've moved to a new pc and for some reason I thought that when you
>backed up, a new file was created. Am I right? At the moment, it's
>just backing up to the backup file. So I've just just my working file
>and my backup file. P...I want to save an Excel file in "Pipe Delimited" (instead of csv).
I want to save my Excel file as "Pipe Delimited" (instead of csv) or else, if
csv, then all values from a column to be enclosed in double quotes and not
just the ones which have a comma in their values.
See www.cpearson.com/excel/imptext.htm for details and example
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"J�Zee" <J�Zee@discussions.microsoft.com> wrote in message
>I want to save my Excel file as "Pipe Delimited" (instead o...Question about Xml Schemas "qualified" and "unqualified"
In the textbook, there is a sentence that "Default XML
namespaces(xmlns="...") helps a lot, but can also create problems, as a side
effect of the rules for automatic qualification. How to understand "automatic
qualification" here? Could you please give me an example? Secondly, unless
otherwise specified, a schema prescribes that loal elements and attributes
must be "unqualified". What does "unqualified" mean? Could you please giv eme
an example? Finnaly, could you please tell me what's purpose of using these
two things? Thanks a lot!
...weight measurement Excel
I want to apply a weight measurement in Excel of Stones and Ounces, cannot
work out how! thanks
Can you explain in detail how you wish to apply this?
(remove nothere from the email address if mailing direct)
"edroberts77" <firstname.lastname@example.org> wrote in message
> I want to apply a weight measurement in Excel of Stones and Ounces, cannot
> work out how! thanks
well i have a column in a spreadsheet that indiates a users weight. I want
the measurement to be in stones and pounds...How to change chart legend text (Excel 2007)
How cna I change the text in a charty legend. They all say "Series1".
Don't your series take their legend from a header row?
"Prof Wonmug" <email@example.com> wrote in message
> How cna I change the text in a charty legend. They all say "Series1".
On Sat, 19 Dec 2009 11:06:46 -0000, "Bob Phillips"
>"Prof Wonmug" <firstname.lastname@example.org> wrote in message
>news:kv3pi5dlerubjclhcgmgsueg16q6pn...a question and a question
What is the correct name of the type of selection box used in "customizing
Word", for example.... you select a word or operation from a list on the left
pane and move it over to the right pane.
Is there a template to build one of these?
You will have to explain more in detail what you are trying to do.
Microsoft Word MVP
"cliffordjf" <email@example.com> wrote in message
> What is the correct name of the type of selection box used in "c...excel vba problems
1.for excel VBA programming, how to get the row value and column value of an
active cell ?
2. if XX="YYY" then XX=10, if XX="iii" then XX=8, if XX="ooo" the XX=5,
-------- How to shorten the uper express ?
2. As alternative
select case XX
"Martin" <firstname.lastname@example.org> schrieb im Newsbeitrag
news:#trVx#TmEHA.3156@TK...IF AND question
I need a function that can provide one of three answers:
1 2 1 1...
3 3 4 4...
? ? ? ?...
If A1 = 1 and A2=3, answer 106; but if A1=1 and A2 = 4, answer 104; but if
A1=2, regardless of A2, answer 95.
The next function for column B is the same, except the answer is dependent
on the value delivered from the column A function. E.g. A3 + 6 or A3 +4 or
Any help would be most appreciated.
Use the below formula for your first query.
...IE8 privacy question
I am running XP-Pro SP3 and considering upgrading from IE7 to IE8.
I have read all the feature and benefit articles from MS, but have one
question that remains unanswered.
In IE8 there is mention of being able to restore previously viewed websites
or something to that effect. I think this is on a drop down menu somewhere.
1) Does In-private viewing prevent this?
2) Does manually deleting your complete browsing history clear this?
3) Is there a registry entry that can prevent this action?
4) Is there a group policy change that can prevent this action?
In essence for privacy pur...Question about Paste Special
Hi, I have a problem sometimes with the paste special options when goin
from one excel workbook to another. For example, sometimes when I cop
data from one workbook and then paste special into another, I get th
options that include: All, formulas, values, formats, has the option t
transpose the data and paste link among other options. And the
sometimes I try and paste data to another workbook and I end up th
paste special options: Bitmap Image Object, picture, bitmap, and I als
lose the ability to paste link. Well you can do it, but it puts it i
as an object.
What I want is the first past...Auditing on Microsoft CRM
I need to know how one can properly audit user access,
changes to CRM records etc.
Is there a way to configure this within the application, or should this be
done at the database level.
These guys have a solution for this:
Never uesd it myself so cant speak for it but looks pretty functional.
"email@example.com" <firstname.lastname@example.org> wrote in
>I need to know how one can properly audit user access,
> changes to CR...Microsoft Query question
I am trying to use Microsoft Query to get data from my SQL 2000 databases.
The problem is that I have a few columns with names that conflict with
keywords (like Identity). (Yes. I kow that keywords should be avoided but it
is done and cannot be changed.) This is causing a keyword syntax error
within the Query application.
Oddly enough, even if I do not select the column the error still appears.
And when you look at all the columns available, the keyword named column
shows up in boldface.
When I am doing queries in other programs I put square ("[ ]") brackets
around column and table...Question
Why did the chicken cross the road?
Dr. Stephen Hopkins, MD
"Dr. Stephen Hopkins, MD" <DrStephenHopkinsMD@discussions.microsoft.com>
wrote in message news:B8434E21-DDA3-44D7-B39B-CD5A8C33A7BD@microsoft.com...
> Why did the chicken cross the road?
> Dr. Stephen Hopkins, MD
To collect her email, why else?
You should be ashamed to put such a title on an idiotic off topic post !!
MS-MVP. MAIL. [DTS] UK.
> "Dr. Stephen Hopkins, MD" <DrSte...csv format changes numbers
I need to save my file in a csv format. When the file is reopenned, some of
the numbers are in a date format and others are in exponential format. How
can I format the number to keep the numbers from changing format. I have
tried various formats before savint the file. In this instance, the numbers
represent part numbers and the file is being imported into my business
software to update pricing.
If you are re-opening in Excel, the behaviour you describe is typical.
Have you tried opening the *.csv file in Notepad or similar application?
Gord Dibben MS Excel MVP
On Wed, 21 M...Excel 2003 font problem
Hey guys, I'm using Excel 2003. The standard font is just the regular Arial
font, and I've never had a problem. Now when I open something, everything is
in italics, and when I check the font, regular for Arial is not there. If I
reinstall the font, then it's all there again, but every time I turn my
computer off, turn it on, and go to excel, the same thing happens. Is there
any way to fix this?
Have to tell you I am no expert, but I would suggest to see if the problem
Go to Tools, then Options, then General and have a look at the f...Changed from M2004US trial into M2004UKversion
I started with Money 2004 US trial version.
Now I bought M2004 UK.
Using now the UK version, the money file created with the
US version generates errors.
Please advise how to "import" the US file into the UK
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://register.microsoft.com/mswish/suggestion.asp
or email email@example.com especially if it's a...OWA Question #16
Quick Question regarding OWA. We are about to finalize migration from 5.5 to
2003. We have an existing web presence already in DNS a www.mydomain.com.
and running on existing web servers. With 5.5 natrually, to access OWA, it
This will not be possible now since OWA runs off of the Exchange server
instead of relying on our web server under 5.5. What's the easiest way to
If you can afford the extra license, you'll probably want to run a front-end
server so no one is connecting directly to the Exchange database s...How can I change the arrow keys...
to move from cell to cell instead of scrolling through the excell sheet?
press the scroll lock button on your keyboard.
>to move from cell to cell instead of scrolling through
the excell sheet?
> press the scroll lock button on your keyboard.
> >-----Original Message-----
> >to move from cell to cell instead of scrolling through
> the excell sheet?
...VBA//Oracle Interfacing Question
I have been able to correct to my database but I have one question
Within objSession I want to list all available tables and all
How exactly is this done?
Set objSession = CreateObject("OracleInProcServer.XOraSession")
Set objDatabase = objSession.OpenDatabase("", "User/Pass", 0)
On Nov 16, 12:05=A0pm, jason <jason.mell...@gmail.com> wrote:
> I have been able to correct to my database but I have one question
> Within objSession I want to list all avail...Text Box Question
I have been using Visio for years, however, something has happened and I
can't figure out how to undo it. Basically up until today when I added a
text box and entered text, the text went horizontal as it was typed. Today
when I add a text box and enter text, the text goes vertical. How do I get
back to the old behavior?
using text container shape adjusting tool (text block tool), make the text
container shape wider horizontally.
Have you used Asian text font recently?...check help for "vertical text"
"Ray Batig" wrote:
&g...Change CRM 3.0 Default Font
I use CRM at work and from home, and the font for messages is always Arial
at home and Tahoma at work. Is there anywhere to change this? The only
difference is that at home I use XP, at work Vista.
I just started a 401K at work and I'm wondering how to deal with it in Money.
I've got my paycheck split into different categories currently and now I
have to put the 401K amount into a category as well. I didn't see one
specifically for this. What do other people use?
Should I start using the 401K Manager? I haven't gone through it yet I'm
just wondering if it works well and how much benefit I'll get from it.
Thanks in advance!
You will want to create an investment account for the 401(k) and TRANSFER
your contributions from your checking account to the...If / Then Question
How would I do this:
IF A1="N" then I need A2 and A3 to="N/A
pknivens's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2767
View this thread: http://www.excelforum.com/showthread.php?threadid=47531
> How would I do this:
> IF A1="N" then I need A2 and A3 to="N/A"
In A2 and A3 use this formula > =IF(A1="N","N/A",""), this will return
blank if A1 is not N, if you want it...ROWCOUNT question
The below is a UDF that returns the ROWCOUNT for a table. I need to know
for WHILE loop.
How do I take the Returned value from the UDF and load it intio a variable
in the SP where it was called from? Or maybe there is another way.
ALTER FUNCTION [dbo].[RecCount]
SELECT Rows FROM sysindexes
WHERE id = OBJECT_ID(@TableName) AND indid < 2
Eric S (xxx_noSpam@Hotmail.com) writes:
> The below is a UDF that returns the ROWCOUNT for a table. I need to know
> that va...