I don't know "math english" well so forgive me mistakes.
I've got a question.How should the formula look which will: take number
from A2 cell and shows me 2 digit number in one cell and 10
multiplicity in another

Hi,
I am trying to create a easy to use look up tool for adresses. IE a user
will enter a Postcode(zip code) and a number (say 8) Adresses will be
returned. I have used Vlookup and this returns the first value it finds. Is

I wish for certain cell to be say green if date entered is within one year of
todays date.  Then change to red if date is over one year of todays date.  I
know this is possible but cant get the right formular

Hello excel gurus.  I've got a spreadsheet of my bank transactions.  If
the transaction description contains a keyword from another list, I'd
like to assign it a category from the next column over.
For example:

I've a table of records. Each record is filled in the spreadsheet by a macro
automatically. Column B is for the "Department's name" and column E is for
the "input date". When each record is filled along the rows, the department
name is not in order. Please advise how to sort the ...

I have MS Office Professional 2003, my data menu doesn't have xml as an
option. Where do I find it? This is time sensitive, I'm a student and have a
project due.

Hi I am trying to sum a column of numbers by month and am having trouble with
the formula (see below).   I am getting a return of VALUE.  Any ideas where I
am going wrong?
Thanks

Hi
Can anyone help.
I want to do a VLOOKUP and bring back the cell below the cell which is found.
eg normal vlookup - VLOOKUP(a1,SHEET,5,0). But I want to bring back the cell

Is there a way to have copy paste skip rows when copying a formula. Here's
what I am doing
Sheet 1 has data in
A1 data

Heres the problem:
I have multiple steps to my drop down boxes. I'm using the data validation
method of linking the boxes, but the last one i would like it to come up with
a given price for my product, other than using a huge 'IF' statement, how can

How do I make it so that if someone inputs a month for an action that it
automatically makes the next column (month of review) have the value of the
month after e.g. for an action in March it will need to be review in April

I have three seperate conditions comparing 3 different columns of data that
return a true or false answer.  I would like to reduce the three formulas
into 1.  If any of the 3 conditions are true, I want my answer to be true.    
My feeble attempt is

I have tried both the concatenate function and the A1&B1, for example,
method.  
In two separate workbooks, I have two different problems!
1.  In one workbook, only the formula is displayed.  As I enter it, it

I am trying to enter an IF function that has several arguments in the
formula. I can get it to return a value up to a certain point (8 arguments),
but after that, I get an error. I am by no means an expert in excel, but
can't seem to figure out why this is happening.

Good afternoon, I have a problem that I have been trying to figure out
for a while. Let me first start by saying that I am not the smartest
person in the world I learn everyday. We have a poplulation of 1563
students. Are program will only allow 1110 students. We have 3 tests we