Hi, I am using Excel MSOffice Xp (2002) and would appreciate help with the
"if" function. I am trying to create a Retirement formula and running into
all sorts of errors and will try and explain the scenario.
In the most simple context, I am basically trying to create a formula ...

I just cannot solve this one. Any help you can give is much appreciated......
There are 12 sheets labled Jan, Feb Mar etc. Each sheet has the following
Col A - Name
Col C - Data to be summed

I've been searching the internet for the past 1.5 days and have yet to find
an example of the formula I'm looking for.... so if this is easy, I apologize
in advance.  
I want a count of the number of cells where column "I" values = "NA" and

I am trying to use autofill to copy a sheet reference as follows:
=sheet1!a1
=sheet1!a1
=sheet1!a1

how can i change figures into text in my excel sheet
for example    200   becom tow hundred, 3200   become three thousand two
hundred

I have created a worksheet to track work orders.  How can I utilize tabs to
view the report by  broken out by month, while maintaining entry of data on
the master worksheet?

I have a document that uses hyperlinks.  At the moment, I am inserting
indivual hyperlinks which inserts the file location for each sheet and the
display text.  This file is over 200 pages and I need to learn of an easy way
to edit each hyperlink easily.

I want to change the format of a blank cell (B2) when the value in another
cell (A2) equals “X”. I have tried to use conditioanal formating, but there
is a formula in cell A2 that creates the value “X”, and I can’t seem to get
the right info into the conditional formatting in ...

I am trying to empty a cells content based on the value of another cell.
Example: if cell A1 is "X" and cell B1 is "X" , and the contents in cell A1
is changed to "Y" then I want cell B1 to be emptied.

I need some assistant in writing a formula that will match to columns"B" &"E"
and give me the data from another column "F".   (this data coming from two
different databases and they are not linked in a dos system we use)
if "b"&"e"(match or equals)put oper name in "D"

I have two worksheets.  Worksheet 1 represents a bulk listing of all unpaid
bills by customer number and its run at the beginning of the month.  
Worksheet 2 represents the bulk listing of unpaid bills at midmonth.  I want
to be able to compare the worksheets by customer number ...

I m using Excel 2002. My data looks like this:
    a         b        c        d
1   yellow Green Brown pink
2   16       12      14      15

i have formula '=G3-G2" in cell g4.  when i dont have any info in g3 or g2,
g4 shows #VALUE!.  is there somethin i can add to the formula so that if g2
and g3 are blank, g4 will be blank too?

I have used a formula:
I have a master sheet that has all unpaid bills. i have added a status
column to the master sheet which this formula in it.
=IF(D3="","",IF(ISNUMBER(MATCH(D3,'Week 2 Dataset'!D:D,0)),"","cleared"))

Hi, I'm trying to write a formula that will look up something in column A
and, if it finds a match in column A in another spreadsheet, will return the
value of that match that is in the same row in column H.
In other words, if I have "Apples" in column A of spreadsheet 1, I want ...