I need a formula that can be use for different kind of asset calculations for
example
a 401k  that has a value of $10,000.00 and is multiply by interest rate of
2% and I need to subtract $1000.00 for cost to sell (sometimes that cost to

What I am trying to do is:
SheetA has names in column D
Sheet B has the same names in column B but different order
I want it to match the names in sheet A column D and sheet B column B and

Is there a way in Excel when you are using data entry from a drop down list
to start typing and have the menu show the list options, instead of having to
scroll through EVERYTHING? For example, if I had a list with names on it, can
I start typing "gram" and have the menu show the ...

what is the Labor % in g7
5       a               b            c              d             e        
    f             g
6      Date         Sales    Emp Work    Hours   Labor Cost     Day    

if b7 is 1000 and e7 is 103 what is the persent formula in g7?

I wrote in the cells miniscule letters now I want to change the majuscule
letters  , somebody knows how to do it?

Hi ppl.
I've been using functions to make symbols from the Monotype Sorts font
appear.  I've always been using the CHAR(186) way of doing it, but it's not
working anymore.

When i enter a number in "G" from "K"  i need "H" in that row to equal what
the number is straight across from "K" in "L".
         G       H             I                    J           K          
 L

I would like to find books that are advanced with Excel formulas. Do
you have any suggestions. I want to learn all the advanced functions/
formulas such as =Switch, =IIF(And, and all the complicated formulas.

I am setting up a time sheet template in Excel 2002. Below is the setup.
Col A           Col B       Col C         Col D        Col E        Col F    
      Col G
Date    Task Area    Time In     Time Out    Hours    Rate    Amount Due

I created a spreadsheet that tracks manhours 7 days a week with the week
starting on Saturday. Our main workdays are Sat thru Thurs and we have a
skeleton crew on Fridays. This is a very large project so I track the average
manhours of the first 6 days ONLY. I don't use Fridays.  ...

i am using MS Excel 2002 Ver. I have numerous filters set up in a spreadsheet
but wish to be alerted when any one is applied. Is it possible to change the
colour of cells when any one of a number of filters is applied, this would be
in the form of a banner across the top of the ...

I want the weighted average of selected items in an array.  The items should
be identifiable by a criteria.  For example if column A5:A12 has characters
A,B,A,C,A,D,E,E and columns B5:B12 and C5:C12 have some values , I want the
weighted average of columns B and C using A as the ...

I'm trying to set up a spreadsheet using drop down menus
I currently have some 120 rows.
In the first column the are 4 possible choices of form (approx 30
records will have this value). However these values will change

I have entered in duration of times (hh:mm:ss). When I tried using the "SUM"
function. The answer wasn't correct.
Do I need to format the cells a particular way for the answer to be correct?
I do NOT want the answer to come out as a decimal.