I.m sure this is simple if you know how but i'm confused.
I have a cell that I want to return 1 of 3 values, these bein
"Ongoing" "Complete" or lastly "Overdue"
Condition 1 Ongoing is returned if the date in A1 is less than the dat

I want to use VLOOKUP and INDIRECT.EXT to help produce a summary spreadsheet
from a number of files.
Cell C10 contains - =CONCATENATE("'D:\Documents and Settings\fzvtc6\My
Documents\EDS

My "problem" seems trivial compared to some - almost embarrassed to ask
I want "sum Of" to be the default for a particular pivot table. Is there a
way to do this?  I don't want to click and change every field - takes too long
TIA

When in excel and linking a cell on tab one to say tab 3 within the workbook
I have previously been able to double click on the item and the program jumps
me to the source cell.  Currenlty what happens is that the curser just
remains in the cell and awaits edits - perhaps it ...

I am trying to create the following formula:
I have two colums (A and B) with numbers.
Formula 1 checks if A>=5250.001 and B<=5000 then returns CIR2
Formula 2 checks if A<=5000 then returns CIR1

I want to be able to enter a product code in one column and based on the code
i have entered, get the product description to automatically appear in the
column next to it.
There are approx. 150 product codes and descriptions.

I know this is simple but can somebody tell me how the below formula
should be written
=IF(C2="PARENT" AND B2="B",90)
I know the "AND" part in the middle is incorrect

I am trying to write a formula to calculate the stamp duty in the UK as
follows for Excel 2000.  Below CELL is the value of the property purchased
i.e £310000
If CELL value < 250000 then answer = 1% of CELL value

I have a table with project names in column A, Resource names in column B,
and the amount of time each resource will spend on the project in Jan, Feb,
March etc in columns C, D, E etc.
On another sheet, I want a summary table, which will have the totals for

In English, what I am trying to do is:
I have a spreadsheet where people put in the client activities (demo,
quote etc) by month (i.e. July = 1, August = 2 etc (peculiar financial
year!))

I need the
=IF(AND(H126>=4001,H128>=0%),100%*(H129),IF(AND(H126>=3251,H126<=4000,H128>=5%),50%*(H129),0))
Need only the 5% the except a positive or negative 5%

Hi - I have 2 coloumns of mixed data, 1 with values and 1 with a
catergory code. I would like to summarise the data, ie I may have 50
items of catergory "STK" but would like to know the total value.  The
aim is to have 2 sheets in excel, 1 as a summary page, the other as the

I have a worksheet in which the user enter's a lowercase "x" in the L column
if they wish to calculate the Labor cost and/or a lowercase "x" in the M
column if they wish to calculate the Material cost and/or a lowercase "x" in
the E column if they wish to calculate the Equipment ...

I have a frequency distribution that counts the occurance of 1, 2, 3 or 4 in
column C but for some reason if there is a 0 in a cell it gets counted as a
1. Here is an excerpt from the spreadsheet.
Row      Col P          Col Q Formula in Q3-Q6 =FREQUENCY(C10:C2000,$P$3:$P$6)

I am not too sure how to explain it so I will provide an example.
Column C represents how many times that name was shown.  Is there an
easy way to do this or a simple formula?  I appreciate the help
A          B         C