I tried the following two formulas, which should be producing the same value,
but I either get a blank cell or N/A.  I have copied this formula and am
positive that it should be working.  The same formulas works sometime and not
other times in other cells.  Is there anything with ...

I have a 3 column table which looks like the following
A1..5  B1...2.0   C1  8.0
A2..12  B2...3.25 C2 11.0
A3..16  B3...4.65   C3 15.5

I want to move cells from one page to another by using a formula, or
basically without having to manually enter then numbers. I am sure
there is an easy way to do this i just cant figure it out

I have few rows which are alphanumeric cells, I need to extract only the
numbers from the cell.
For Eg: One cell contains fjdslfdslflsd455646sdfds768468
Second cell contains fsdfsd4879899 fsdfdsf547555sdfds797988.

I am running Excel 2003 SP2 and have been trying to figure this out for 2
days. I have reviewed all of he postings and cannot get this to work. I have
a 4 sheet workbook. In cell A16 of the 3rd worksheet I have the formula
=IF(AND F10>=2,F11>=2,F12>=2),"COMPLETED", "NOT ...

I am trying to write a spreadsheet for tracking man-hours worked over a pay
period.
What I want to do is sum the fields for the first week, and if the total is
greater than 40, convert the remaider greater than 40 to a value in another

I need to create what I would think would be an IF formula for quite a large
group of measurements. Here is an example of what I am working with...
A              B
Score    Rating

I have two tabs in workbook
Tab "Blank" which contains a table with two columns "A" & "B" and rows
"42:69."  In column A you place an "x" to signify the text in column B is to
be used.  At the top of the table I have a row that does Autofilter lookups.

how do i get the count if function to count based on certain concrete
conditions...if cell a1 >= condition a and <= condition b then add 1
to count...

I have the following data in a table (6 rows, 3 columns):
A       .02         2/1/07
B       .05         3/1/07
A       .02         4/1/07

How can I leave a cell blank following a response to an "IF" function?
Because in Excel 2007, the default response in a cell is "FALSE" when I leave
a cell in question to the "IF" function blank. This is because I would like
to be able to leave those cells in question to the ...

Here is an example what I am trying to do:
$        %
35      30.71  
27      23.68

I have 3 col of information:
Col A=dates
Col B=acct numbers
Col 3=currency

I'm trying to setup a product catalog that will allow a seperate worksheet to
perform a VLOOKUP of a product number to retrieve the product description and
price.  What I'm finding is that if I create my catalog in a structured way
(ex: Home Software, Work Software and Server ...

I have a list of contacts with email addresses. My client is changing their
email layout from jsmith@client.com to john.smith@client.com. I would like to
replace the jmsith with john.smith, which I can get by concatenating the
first and last name columns with a dot, but how do I ...