I'm trying to calculate a formula in Excel using the IF function.  Here is my
code.
=IF(B2>=9/1/2006,5,IF(B2>=6/1/2006,4,IF(B2>=3/1/2006,3,IF(B2>=1/1/2006,2,IF(B2>=9/1/2005,1,0)))))
Basically this is what I want returned.

All I want to do is to say for example that Cell A1 is equal to Cell G8 and
have A1 contain the same text as G8 and have the same fill colour

I am using VLOOKUP to return a date, however it returns the number of the
date, rather than the date. I know that Excel stores dates as numbers, hence
how do I get around this?

I am using the REmid function to pick out 13 character strings that end with
l, h, c or u.
e.g. cell A1 contains....
FIELD C2 @CHANGE ("PRPPRUNWECEOl") SIGN NOZERO;

I have an exercises where I have a list of different names, of different
lengths but I want a result which packs out the name with trailing spaces so
that the final length of the name and spaces always equals 15 for each.
ie john needs 11 spaces added to it for the length to be 15 ...

I would like to check to see if a cell has a comment or not, without using a
macro.  In other words, If the value of the cell is between 10 and 20, and
there is not a comment attached to that cell, I want to display "No".  If the
value of the cell is between 10 and 20, and there ...

How do I get excel to quit looking for a add in that has been deleted? I am a
bit of a novice so lack the expertist needed for this.
Thanks Anyone

Is there a formula or method that will convert the barcode printed on book
to the ISBN. - I can scan the barcode into Excel eg barcode is 9781585955565
and the ISBN is 158595556 - the last digit in the ISBN number is a checksum
digit, but I really need the ISBN.

Dear friends,
I have the list of names that changed with the time. I need to compare them
and find out the differences. Anyone can help me with this issue? Any
assistance will be appreciated. Thanks beforehand

What I am trying to do: Create cell labels that are a composite of the
contents of other cells.
Example: An investment club contributions sheet for all months and all
members

Pleas help.  I have a spreadsheet that was e-mailed to me and it is not
sorting the data properly.  I am trying to sort by decending order and
this is what happens:
828  

As a frequent user of the Hide Sheet function in Excel with Excel files
generally exceeding ten sheets, the ability to unhide more than 1 hidden
sheet at a time would add tremendous time saving while using the Excel
application.

I need to be able to calculate a rate of return on deposits/withdrawals at
uneven intervals, and keep running into a problem with XIRR when first
deposit is small.  Simplified example:
-$100  1Mar98

I would like to know how to round five minutes to an hour and five minutes
after the hour to the nearest whole hour.  (ex.  round 7:55 and 8:05 to 8:00)
Thanks,
Ana

I'm playing with some color vba from cpearson.com but can't seem to
automate the process of summing the last x number of y colored cells.
I'm having to change ranges every time I copy the formula over.
Using the info on this page, http://www.cpearson.com/excel/colors.htm,