Functions

ms excel
how to change uppercase to lowercase in ms excel ... 15 Mar 2010 07:53

enhance a function of single character to a combination
some time ago, I was kindly provided with a primitive codes followed with my modifications as follows. The function is capable of coloring a text pattern input by users. I would like to enhance it to a more robust way in: 1) instead of adding escape character for ], ', etc. is there any way to let the program ... 15 Mar 2010 12:21

How to set a formula if the value is with #N/A
Example : E/no salary Bonus total 001 1000 #N/A 002 200 100 003 2000 #N/A How to set a formula for each worker in total column (Salary & Bonus)when the value are set as #N/A. How to convert #N/A to 0 for sum formula. Please advise. Thanks. ... 15 Mar 2010 01:22

Printing Worksheet
Is it possible to print a worksheet which shows the cell nos and row nos. If you check the comment box which sais " show comments at end of sheet" it states the particular cell for each comment, but relating that to the actualo cell on the worksheet is difficult. If the work sheet showed the cell references, t... 14 Mar 2010 23:11

Starting drop down lists at the top
I have several drop down lists on sheet 1 where the data sets are on sheet 2. Some of my drop down lists start at the first entry and others start at the middle of the list. How can I get all my drop downs to start at the beginning of the list when the drop down is clicked? Thanks for your help! -- test123 ... 15 Mar 2010 02:27

prevent div/0 error
I am building a gradebook with limited knowledge of Excel. To get a weighted percentage, I came up with this =(I4/I$3)*0.05+(Y4/Y$3)*0.2+(AJ4/AJ$3)*0.2+(AU4/AU$3)*0.25+(AW4/AW$3)*0.05+(AY4/AY$3)*0.1+(BA4/BA$3)*0.15 However, the last few have zeros in the denominator (for example: BA3) as there is no grade for... 15 Mar 2010 02:27

Compound Interest Rate or Growth Rate
Is there a function in Excell that can be used to calculate an investment"s compound growth rate? If so what is it and how do you use it? For instance if someone invested $10,000 in 1985 and that investment was worth $18,000 today is there a function in Excell that can be used to determine that investment's ... 15 Mar 2010 01:22

sumif
I need to sum two cells together as long as either of the two cells have numbers in them. If either of the two cells has "A" in it, then I need to concantenate the two cells. Like this: E is the column where the formula is. A and B are the columns where the cells are to either add or concantenate. A B C... 14 Mar 2010 19:54

slow worksheet
why does it take so long to open an existing worksheet ... 15 Mar 2010 01:22

Lookup for this?
Hi, In col A I have numbers 1 to 500 in sequential order In column B, I have values against each of these numbers In column C I have numbers 1 to 500 in non-sequential order In column D I want to match each number in column C with its equivalent in column A and return the corresponding variable in column B to c... 14 Mar 2010 19:54