I've created this if statment, but it's not returning the the appropriate
values.....please help.  Thanks.
=IF(C5="801","Beaumont",IF(C5="APS803"="Lafayette",IF(C5="805"="Houston",IF(C5="806"="San Antonio",IF(C5="810"="Dallas","")))))

Thanks for all the help on the last question, it was very useful and so I am
hopeful someone can once again save me...
I would like to be able to use a numerical ID from one workbook to reference
to a  text cell from another workbook, and insert that text to replace the

I need to find the difference between the maximum and minimum values
of several different groups.  I have the following data:
           A              B
1     1/1/2008       2008

I'm trying to grade a student's file and can't see any formulas (cell
contents are hidden). In advanced display options, the workbook and sheet
options are unavailable. On the menu, protection is disabled. The file says
it is read only even when I resave it to the desktop. What ...

Here is an easy one, but I just can't get it right. I trying to sort data in
a file just opened. But when it get to the sort part I get an "informative"
400 error.
Sub GetDataFromFCDBFile()

I am trying to create a formula wherein I can enter time started, 1:00:00 and
time finished, 2:00:00, and then multiply this total by a dollar fee. Any
help would be appreciated

In at least one Excel 2007 macro-enabled workbook, names I give to certain
cells or ranges disappear from the list in the Name dropdown box as well as
Name Manager when I close and then re-open the workbook. I've been careful to
make sure I save the workbook each time I create a ...

Greetings all,
I am working on a project involving several dozen PDF files containing some
data in tables. I would like to be able to convert those PDF tables to Excel
so that I can work with the data in Excel spreadsheets.

I have a list with names of persons and pictures. Is there any possibility to
sort this list without shifting around the pictures? The picture should stay
next to the correct name even when sorting the list of last name etc.

I have an Excel spreadsheet that has several tabs for diff categories.  on
one tab, i have set up a simple sum formula to add up current expenditures
and totals (orig. budget balance and also funds available). so, i would like
to do a sort of "cover page" for all the tabs in this ...

Thanks for any help.
I am trying to get a cell with a formula and text.
Something like for A1
=B1*C1&"% - "&D1*E1

Looking for help with the following:
Numeric and non numeric data is in A2:F1580, A1:F1 is the header row.
Column C has different names and surnames in one cell, separated by a space.
Some cells have only names, some cells have names, middlenames and surnames

How do i optimize the following code wit 31 cases
here i is the row index (dynamic) and in everycase the estimate gets
subtracted by multiples of 8. so for case 31 we need to have 8*31= 248 as a
subtraction to the estimate. This is quite urgent and i do not know prog at

I have about 15 trackers for individuals.  Every time that list of names
changes, I have to go sheet by sheet and update the list of names.  This can
take over an hour due to the expanse of this list.  I want to create a master
list which will cause the other lists to Auto update ...

Looking for help with the following:
Numeric and non numeric data is in A2:F1580, A1:F1 is the header row.
Column C has different names and surnames in one cell, separated by a space.
Some cells have only names, some cells have names, middlenames and surnames