Does anyone know how to perform a calculation (multiply/divide/...) between
two complex numbers (x+iy)?
It seems that you can get the complex numbers in place using =complex(x,y)
but once on screen, e.g. cell A4 and A5, it does not seem possible to perform

I’m using XL 2000
I have 48 columns, representing months Apr-06 thru Mar-07 (see January
example below)
Users enter a value under the ‘Cashable1’ column for the current month.

I am trying to set up a formula in an Excel spreadsheet to calculate daily,
the end of month projection for total patient visits.  I enter manually a
daily amount, and have the formula currently set up to take the daily average
times the number of days in the month and subtract ...

I need to create a hyperlink that will pull info from cells in a worksheet
i.e. - IN THE FOLLOWING HYPERLINK WHICH REPRESENTS THE PAGE I AM CURRENTLY
ON I WOULD NEED TO REPLACE THE WORDS IN ALL CAPS WITH INFORMATION THAT I HAVE
IN SPECIFIC CELLS IN A WORKSHEET

I remember calclating someones age before in Excel 97 but have forgotten the
formula.  =now()-birthdate or something similar.
Can someone help me?
Many thanks

Ive been racking my brain trying to figure this out on my own but can't seem
to get it right. The problem that I have is I am trying to match phone
numbers in a column with a data base of the first 6 digits of the number that
I can call, and either get a true or fasle or any ...

what is this called :

What's the method for Cell Border in the code module.

Thanks for all the advice about the conditonal formating, however, I have
another question regarding data validation.
I would like to set u a control in which when user enters anything in Col A,
it is required that Col B, C, D have to be entered as well.

Does anyone now how I can let the text colour change according to the number
in the cell? If the number = 6 or above the text needs to be geen, If the
number = 5,9 or lower the text needs to be red.
Thanks for any help,

how can i d2/2 then round up or round down the results?

I have some formulas in a couple of cells but I don't want them to calculate
yet. Some other cells are dependant on it and I would like it to show a - in
the cell. The situation is that it deals with inventory for a place that
sells vehicles. I don't want trade in cars to ...

Hello all experts,
I have a worksheet which contains the data, and I would like to set up a
data validation function that whenever a user updates a cell, the cell will
change the color from white to red.

I have worksheet that has over 2000 players name and stats... What I want it
to list the top thee point leaders by there stats in separate column.
     A             B               Ga   Assists   +/-    Ponits
9   Name 1       Last Name 1        7          6         7         20

i have a index value in each cell ranging from cell A24 - A280. Every 4th
row.
A24,A32,A36.........A280.
What i want to be able to do is if i delete some rows(always 4 rows at a