Is there an equation in Excel to use multiple if then statements?
Please post your question in the body of your message, not just in the
heading. Some systems cannot cope with "empty" messages.
Look in HELP for AND and OR, or post more details of what kind or multiple
if statement you need.
"Cody5" <Cody5@discussions.microsoft.com> wrote in message
what do you mean by "multiple if then statements"?
You can nest them:
=IF(condition1, true1, IF(condition2, true2, false2))
you can have multiple if's sequential...EXCEL PROBLEM
I OFTEN MAKE FORMS AND SPREAD SHEETS FOR OUR OFFICE USING
EXCEL. THIS HAS NEVER HAPPENED BEFORE. I AM GETTING "NOT
ENOUGH" POP UP BOX WHEN TRYING TO MAKE A NEW SPREAD SHEET
TODAY. THE FULL MESSAGE IS "NOT ENOUGH SYSTEM RESOURCES
TO DISPLAY COMPLETELY. PLEASE TELL ME THAT THIS THING IS
NOT GOING TO CRASH AND I AM ABOUT TO LOSE ALL OF MY WORK.
CAN SOMEONE HELP? I AM USING 97 VERSION.
There are a few things that can be the cause of this ...
You have too many applications open.
You need to clean out your temp files...
You need to do a scan disk and poss...Asks to insert Disk 2
Had Office 2000. Upgraded to XP. Can't open Publisher
without inserting Disk 2 of 2000. Deleted, reinstalled,
downloaded all updates and patches. Still won't open
Publisher without inserting Disk 2.
PUB2000 Error Message: The Feature You Are Trying to Use Is Not Available
Mary Sauer MS MVP
"Glen" <GFGriffin@msn.com> wrote in message
> Had Office 2000. Upgraded to XP. Can't open Pu...Macro size limit?
Is there a limit or a desirable maximum size of a macro? for instance one of
our users has recorded lots of actions into one macro (and intends to keep
adding to it). At present the macro is 117kb (13 pages of printed text).
He can split the macro into several separate ones if size is an issue.
Thanks in advance.
You should split the module in to several modules, each less than 64KB.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Belinda Robinson" <email@example.com> wrote in message
news:bovrh...Suppressing auto format in Excel
I have a .CSV file that is automatically generated by a program.
Apparently, when the file is opened with Excel, the numeric fields that are
enclosed in double quotes in the file and look like "123,456.1234" are being
formatted by Excel and displayed with only 2 decimals. The cause of the problem
seems to be the comma in the number, which I don't really want to remove.
Is there any way to suppress automatic cell formatting in Excel, so the
contents could be displayed just the way it appears in the source file?
In the Text import wizard - step 3 of 3 - select the offending colu...what is the fastest way to sort?
I have a group of ~100 elements, each with a score of 0-1000.
What is the fastest way to sort them?
Now I simple put them in std::vector, and then use std::sort.
Is there a faster way?
I use Visual Studio 6.0.
On Thu, 17 May 2007 03:11:01 -0700, dududuil
>I have a group of ~100 elements, each with a score of 0-1000.
>What is the fastest way to sort them?
>Now I simple put them in std::vector, and then use std::sort.
>Is there a faster way?
>I use Visual Studio 6.0.
I did some t...Outlook 2010 feedback -- To-Do Bar has no way to select which cale
(MS Connect site doesn't have any way to provide feedback for Outlook 2010)
To-Do Bar has no way to select which calendar provides the upcoming
I use several accounts -- personal and work, and I am unable to select which
account's calendar is displayed in the To-Do Bar, and which provides the
upcoming appointments content.
I am using an Exchange account for my work email and a couple of Windows
Live Hotmail (Office Live Small Business) Outlook Connector accounts.
The default calendar is always used in the To-Do bar...Failed Updates for Excel 2003 (KB978474)
Does anybody have any idea why the recent update from MS for Excel
(KB978474) would not update and what can I do to get this update through?
I keep getting the below message and not much of any description what I
The problem is that:
1. After failure, the Windows Update does not stop (unless I turn it off
manually) and still tries to install this update
2. After each update Excel is somehow corrupted or uninstalled. After
attempt to start it, it reinstalls and than runs seemingly OK.
I seem to be unable to break this vicious circle.
I tried to reinstall Exce...Transfering Dos to Excel
Is there any way to transfer Dos (a program called Lucid 3-D) into excel 2000
so that it can be printed on a printer that does not print DOS?
If your DOS program will export results to file types such as TXT, PRN,
or CSV you could subsequently cause Excel to import from those files.
Lucid may also export to other file types supported by Excel.
It doesn't export as anything as far as I can tell. It will dump out into
another program...in DOS. I can put in a window and copy column by column
what is in the window and paste it in Excel...but I can only copy what is on
the screen. I c...Microsoft Excel 2000 Software.
I need to know the steps to take to look at the driving
game Easter egg in the Microsoft Excel 2000 Software.
...US Letter Size not displaying correctly with the rulers in Word
Operating System: Mac OS X 10.6 (Snow Leopard)
In Print Layout View the rulers are displaying the incorrect measurements for US Letter. When I print, the output on paper does not look anything like the Print Layout view. <br><br>When I view the rulers, they are only showing about 7 1/4in for w, and 9in for length even though I have selected US Letter (8.5 X 11) under page set up. So I am typing in Word with 7X9 and the printer is receiving it correctly since it thinks Word is sending it 8.5 X 11 (this happens when printing to PDF as well) <br...Excel to XML #2
'Is there a converter for Microsoft Excel 2000 files that
will save the files as .xml'.
File, Save As
the file extension is still .htm or .html
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"MS" <firstname.lastname@example.org> wrote in message news:email@example.com...
> 'Is there a converter for Microsoft Excel 2000 files that
> will save the files as .xml'.
...Automating export to Excel
I'm trying to export data from Access into an existing Excel file with a push
of a button. These are the steps that I need to perform and would like to do
it all from Access, meaning all macors or coding. I'm using MS Office 2003.
-Run & export access query to a specific folder location & over write any
existing file (if it cant be overwritten then use the same name & add 1 (or
increase by 1) to the end of the name)
-Open an existing excel spreadsheet. If the spreadsheet is already open,
then open as read only.
(the excel spreadsheet will automatically populate a...Excel using =RC[-1] format and I don't want it
On this machine only, Excel will use the format =RC[-1] when I am
entering a formula on the command line by hand and click on a cell to
reference it in the formula.
I don't know how this got on but I would like it to go off. On my other
machines, it does the old familiar A1:B2 style of cell reference.
I can't even search for how to fix it since I can't determine what this
is called so I can turn it off. The only reference I have seen is a
button that is only effective for macro creating and I am not creating a
macro, just a formula, interactively, in the cell.
How ...Excel drop down lists #2
I am trying to create two drop down lists.
The first is a straight forward selection of 6 choices.
I would like to be able to have a list in the next column which is dependent on the choice from the first list.
For example from a choice of "A, B, C, D" in the first list, if i choose "A" I would like to have a drop down list choice of "9, 8, 7" in the second column. But if i choose "C" in the first list, then I would like to have a drop down list choice of "6, 5, 4" in the second column.
Is this possible? And if so, could you please tel...Is there any efficient way to find a string in a file?
I have a large file. Till now, the only way I know to search a string in it
is to load the entire file in memory, and then compare them word by word.
It works but also inefficient. Could you tell me a better way?
If memory is a constraint you can try using memory mapped files. As
far as searching for a string is concerned, you might want to consider
the boyer moore algorithm.
> I have a large file. Till now, the only way I know to search a string in it
> is to load the entire file in memory, and then compare them word by word.
> It w...please post a 2006 calendar iin excel format. thank you.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
Try File > New and look at the templates available. In particular
I have had Excel 2007 for a little over a year. A few weeks ago, I noticed
that when I double-clicked on an Excel spreadsheet from within Windows
Explorer, Excel opened but the workbook did not. Neither did the "Book1"
workbook. It looked just as Excel would look if you opened it and then
exited the workbook, leaving the application open.
If Excel is opened in this manner and then I double-click a second time on
the workbook, then it opens.
I do not think that this is related to SP1, but SP1 was automatically
installed on 4/11/08. I cannot recall if this problem cropped u...Excel or IE caching csv
I am accessing a website that generates csv reports for many different
facilities I service. The csv files all have the same name and, subsequently,
the same URL. There is some kind of backend script that generates these files
and opens them in Excel for me automatically when I click the appropriate
The first time I click the link, it works fine. The second time, I click the
link that is associated with a different facility, but the data for the first
facility still shows up in the csv Excel file. I have played with IE's cache,
cookies, history, and advanced settings to no av...Insert without disturbing existing records
How do I Insert new rows without disturbing existing records. I am using data
import and then populating the excel sheet. I have tried setting Data range
properties but that didn't help
Where do you want the new data to go? Where are the existing records?
Perhaps you can manually cut and paste at the end of the current data,
or create a macro to append the records. However, to get specific help,
you'll need to provide some details on what you're trying to do.
> How do I Insert new rows without disturbing existing records. I am using data
> import and then...ms publisher 2003 inserting graphic from the web
Have insall at work ms publisher and office 2000, now upgraded to 2003, in
pub 2000 used to select insert graphic and options for access from web
brought you to ms gallery page. In 2003, no dropdown menu shows the internet
option. Have I lost my mind? or is it specific to the install on our
mainframe. HELP. Need my graphics
If you're talking about clipart, just search for whatever and it will
automatically search the MS website.
MVP Microsoft [Publisher]
How to ask a question
"Bruce" <Bruce@d...hide links only for specific tasks?
Does anybody know if there is a way to selectively hide predecessor
links for specific tasks (I mean the arrows between two tasks in a Gannt
I have one or two milestones that have a birds nest worth of
predecessors, but seeing those links contributes very little to my
understanding of the situation, and it clutters things unnecessarily.
The other tasks, on the other hand, have some very important (and few)
predecessors that I would like to see, so I need a system that only
removes viewing predecessor links for tasks I deem a burden to see
Anybody got an idea?
...insert an order number when another sheet opens
I have a form and every time I open it I need it to create a new number. Is
this possible. also if I put it a number that does not correspond to an
other number can it give me a warning.
Thank you so much for your help
...How do you sort in Excel by 1, 1a, 1b, 1c, ...2, 2a?
I want to sort a list of numbers in excel but I want 1A to be in between 1 &
2. Hos do I do that? I tried setting up a custom list, but no luck.
To get the sort order you want all the items must be text. For example,
select A1:A3. Use Format, Cells and select Text as the number format.
Enter 1, 2, 1a in the cells and then click the Sort button on the Standard
toolbar. The order should sort to 1, 1a, 2.
"MChapAcct" <MChapAcct@discussions.microsoft.com> wrote in message
|I want to so...Insert Data Generate Date into an SSRS Report Header
I generate SSIS package multiple table data loads, and write a record to a
data generation table. I wish to insert the last data generation date from a
SQL Server into the header (or footer) of an SSRS report.
Does anyone have thoughts on best practice for this ?
Issue SELECT TOP 1 datecolumn FROM tbl ORDER BY datecolumn DESC
"jm27102" <firstname.lastname@example.org> wrote in message
>I generate SSIS package multiple table data loads, and write a record to a
> data generation ta...