I am using Excel in Office 2003.  My spreadsheet contains a column (H) of
dates in the following format "2-Feb-06."  Another column (J) contains the
formula =H3+10, for example.  In other words I want column J to populate with
dates 10 days past the dates entered in column H.  In ...

I have a green mark in the upper left of each cell after a calculation.
Anyone know what do they mean and how can I remove them?

I have a VLOOKUP that returns NA.  This is not a problem.   In another
column, I want to populate it with data from column X if the value in column
AG returns NA from the VLOOKUP.   Suggestions?
Thanks,

Hi I would really appreciate some help with this problem. I have a table of
data that I am using a lookup on, so that I can preset formulae I am also
using the isblank function to hide the error message when there is no lookup
value entered. What I'm trying to add to this is ...

This what I would like to see in a cell A3. How do I put it into a formula?
ex:
A1 displays a date   "2/1/06"
A2 has function "date" which displays the current date "3/31/06"

Here's my problem. I know a bit about formula's on excel but this one has
got me stumped. For example: I have to different shops with many different
locations. The locations are in different cells to the shops.
Here's an Example

I have a table like this
a           b            c
6.75                     -.75
6.875                 -1.25

Can you please guide me about calculation of Antilog in the excel sheet.
Regards

I would like to test a cell and run a formula if the cell is inbetween two
values.  For example.
IF(A1 <is inbetween values 1 and 100>,"YES", "NO")
I can't figure out how to tell Excel the inbetween part?  do I use A1=1:100

I have a spreadsheet where date fields are being entered in columns J
through Z.  (each column represents a "Week ending date"
I am creating a spreadsheet where I would like the date of the last
(furthest right) column is entered.  So if J6 has a date of 2/26/2006,

I keep an extensive list of contacts in Excel.  The columns are:
FirstName, LastName, Address, City, State, Zip, County
In our sales department, they have the States broken up into regions.  How
can I have excel automatically assign the region number in my list in it's

I'm trying to write a formula that would do the following between tw
sheets:
In Sheet 1 Reference the text in a cell - I'll call it B4
Look at at cells "Sheet2!$R$59:$FZ$69" (yes, I need an absolut

I am trying to set up spreadsheet where I can select a range, by date, from a
couple DTPicker activeX controls, and then sum up some values corresponding
to that date range selected in the DTPicker's from a list of dates from
another spreadsheet. I am struggling at the moment ...

I have company names and addresses with items in separate columns.  How do I
convert this information in columns to avery labels for printing to my epson
photo 1280.  

Hello Team,
Please excuse my ignorance.
I would like to know what the ampersand and the excliamation marks do or
what are they for?