It's probably easier if I ask this using an example, so please reference this
sample:
                 A     B
1    0.3    0.2

I have a list of sequential dates in column A; let's 12/01/05 (Dec 01, 05) to
12/31/05.  I want to use a conditional if statement to evaluate if the date
is less than a given day, for example: =IF(A1<12/15/05,"Less","Greater").  
Therefore the first 14 should result in "Less" and ...

Before i work with a older version of Excel.
Now i get in the screen fx in place of =.
How can i change that?
Thank you for answer.

I want to average a colum of info, but I have multiple product in this
colum. I want do a basic sumif, but average figures. Is this possible?

For a wedding. I have the different meals in seperate columns. I need to add
the number of Beef dinners and the number of Chicken dinners. I cannot use a
number conveniently for the "Beef" or the "Chicken". I tried
=IF(G95="Beef","1","0") with the conditional number "1" going ...

I currently have a long series of records in the structure
Descriptor     Value
ABC             123
DEF             456

I am trying to figure out to split a cell formated with a numeric and alpha
format.  For example, the format is "10100 Accounts Payable"  
I want to split the cells to "10100" (1st cell) then "Accounts Payable" (2nd
cell).

I have an earlier post on this but no solution and trying again.
I have two pages with tables of data with column headings of dates I need to
merge the data from these two pages into a third page in the chronological
order of the date headings and carry along the columns of data ...

While using VLOOKUP, the result is not showing up...only the formula. But
while I was actually entering the formula in VLOOKUP the value was showing
up. But once I hit OK only the formula showed up. Please help!!!

I am creating a timeline with several tasks and there is a review process
for each task. Each review needs to be completed within a certain timeframe
that corresponds to the due date (in other words, review 1 must be completed
14 days in advance, review 2 needs to be completed 12 ...

In Excel I know how to calculate a monthly repayment using PMT but is there
any way I can calculate how long a loan would take to pay off )this is a
question I've been asked and I'm not sure whether it can be done or not).
I thought maybe goal seek but you can only use that on a ...

I am trying to create a form where a user would select from a list of
different products. Depending on the users product selection, certain other
information may need to be populated.  How can I make it so the drop-down
list auto populates other cells (i.e. customer name field, ...

I need to make sure that a cell contains NO SPECIAL CHARACTERS (including
the <SpaceBar>) during data entry.
I've tried:
=len(cellReference)=len(substitute(cellReference,or(char(32),char(34),...etc

Does anyone know of a formula you can use to sort a list of text
alphabetically?
I know the data/sort option but I want something that can pick up new
entries in the original data list without the use having to intervene.

I put up a post the other day, but I think that I complicated my question
too much. I'll try again as follows:
I have two worksheets, one of which is a shorter version of the first. For
example, let's say I have 12 columns in Worksheet1, and 9 columns in