I have 3 excel documents linked between each other. They worked perfectly
fine with Excel 2000, but I need to update to 2003 and these links appear
broken. I try to update with F9 with no good results, and replacing '='
instead of  '=' to renew calculations, starts to do it ok, ...

I want to know how to type a number from 1-27 in a cell and have it
automatically put in numbers in that cell and one other cell off of another
sheet in the workbook.
Example:  If I type in 1 in D3, it would automatically enter  4-3 1/2" in D3

I need help - I actually am trying to do two separate functions, but I
think the formula should be similar for both.
#1:  I am trying to sum a column if two cells in each row are equal.
For example:

HI, I WOULD DO SOMETHING LIKE THIS:
=SUMPRODUCT(--(A2:A500="x"),--(B2:B500=D1),C2:C500)
WHERE (CELL)D1 IS VARIABLE THAT I INTRODUCE
THANKS IN ADVANCE

i have obtained a solution from this Discussion Board which more or less does
what i require.
I have two dates the start date and time (A1) and the end date and time (B1)
Our standard working day is 9:00 to 17:00 with lunch from 12:30 to 13:30

I want to add a column of times in a time sheet.  I can get the hours worked
but can't seem to get the column to add totalhours

I am trying to calculate the working time in the format [hh]:mm for assigned
tasks so that i will be able to log the rate at which different tasks can be
completed and help schedlue for the future.
I was planning to use a macro to copy and paste the value from a cell

Hi.  I want to include text and formula within the same cell in Excel.
Does anyone know how I can do it?
I am trying to acheive (A4*B7)membership+(C3*D10)journals  so it
appears as a number (say 100) but anyone looking at the formula can see

I am collating a summary stock movement which using the sumif function i.e
SUMIF Sheet1!b$1:b$500,a5,a$1:a$500)
Is there a way to shorten the formula as I have presently 40 sheets for one
week which is causing me problems space wise (and hurts the eyes when looking

Hey Guys:
Can one of yuz take a look at this formula related to a 5 Year Automotive
depreciation factor?
Here it is:

Good day!
I want to make a function formula instructing to list down all the same
records based on the inputed by the user, the thing I can't solve. Below is
the table example.

Ok hope you guys can help:
A1= x
A2= y
A3= A1-A2

Dear friends, I`m currently using CSE formulas to extract and analyse data
with the multiple criterias. e.g:
=SUM(('12SP'!$A$2:$A$65536=$A$1)*('12SP'!$G$2:$G$65536=$C$6)*('12SP'!$E$2:$E$65536<=$D$2)*('12SP'!$D$2:$D$65536))..But
unfortunately I have a problem with sheets so that ...

Need to switch positive numbers to negative numbers (or vice versa) in Excel
worksheet efficiently, anyone can help me here?

i am trying to clean up my excel data base. I want to delete all rows tha end
in SMPT. How can i set up the Column to do this easily instead of one by one.