I am trying to put multiple conditions in if like
A1                     B1
Loan                 Sanctioned by
1000

Is there a way to have a drop down list using data validation in file
"jobs.xls" sheet "Sheet 1" Cell C4 to select a contact from a list that is
in the file "parts.xls" sheet "contact" and fill in the corresponding cells
in "Jobs.xls". The list of contacts starts on row 3 and goes ...

Dear ng,
for the following data,
               x                    y
     3,19 4,4

I want to know if it's possible to have a drop down box on one page and have the info within it on a separate a page??? thanks

Help! How do I keep formulas in a worksheet from rounding
up or down. Do I need to do a different formula than =sum
(b2+c2)?

I have a spreadsheet in 2003 using an add it which
provides a button for inserting quote info and another
which allows you to update the information you insert.
When I try to run this workbook in 2003 the quote update

Is there a way to lock the formatting in a Pivot table? For instance when we
open the details for a specific user it throws off the formatting.

I am preparing tables for publication and need the columns to be of a fixed
width.
Can I lock the column width to prevent Excel from widening a column to
accomodate a number. I would rather see a series of ##.

Hello there...
I've a problem... I have in my computer excel and winword files with very
large names. I can't open or rename those files.
Ho can I solve this problem. I have Windows 2000 in the referring computer.

WHen I try to open Excel 2000 I immediately recieve an Illegal
operation..with the message of invalid page fault in module MS09.dll at
167:...... I tried running a repair and a reinstall...I cant find anything
in Technet or on the internet...any help would be appreciated

I'm not sure where to start with this. I am currently accomplishing
this by a cut & paste from Excel into an editor, formatting the data
with an editor macro  and cutting & paste back into Excel.
I have approximately 3,000 rows of data and need to place one of the

I'm using excel 2000. I have a test formula: =IF($N$37=$O$38,"OK","ERROR")
I would like to use one of the boxes in the status bar to display the
result.
I have 8 of them, from L to R;

I have used excel to create a workbook where the topsheet is named total and
the sheets below are presently named Property 1, Property 2, Property 3,
Property 4.  Each sheet looks exactly like the others.  For example cell C1
of each sheet is equal to the property value.  I would ...

I want to insert a forced line feed in a cell containing text. To insert it
in a text I use the <alt><return>.
Now my question is how do I insert it in a cell that I create by merging two
texts.

I have a master workbook on a single sheet that contains all of my data.
I have another workbook that contains individual sheets dividing the
data on my master list into subgroups. This workbook is linked up with
the master workbook.