Excel - using Excel worksheet functions

Thread preview

Thread	Last Post	Replies

What is evaluate formula?	27 Oct 2006 13:52 GMT	11
Is this a command name in Excel? What is its function?
Vlookup w/sum?	27 Oct 2006 13:45 GMT	3
I am working on a spreadsheet where I need to find the value of the product returned in the Vlookup * another number, how do I get this formula to work properly? I currently have
Mathematical Problem	27 Oct 2006 13:43 GMT	3
LOG(A)=B I know B how can I find A in Excel Thanks for any help. John
Determining AM or PM in text string	27 Oct 2006 12:55 GMT	8
I created the following formula: ="As of "&MONTH(NOW())&"/"&DAY(NOW())&" @ "&HOUR(NOW())&":"&MINUTE(NOW()) and I would like to add "AM" or "PM" to it. Can someone help me modify my formula to include it?
how can i transfer fourmular results as a value in a second formu	27 Oct 2006 12:38 GMT	1
I want to know if it is possible to take the results of a formular in a specific cell and tranfer the resulting value to another cell as either a value or input to another formular? Also, can this be transfered between sheets of the same workbook?
how to get zero befor no. means eg 065 in excel	27 Oct 2006 10:29 GMT	3
I want to have zero befor any number in excel sheet but whenever I write automatically it disapperas(eg when I write 065 automaticaaly 0 disapperas and remains only 65)So if anyone know the way to solve this problem please help.
Lock cells, but still be able to trace	27 Oct 2006 10:19 GMT	2
Is there someway to protect your worksheet cells, or at least the formula's in it, but leave the rest open. One should not change the content (being the formula), but should be able to do things like: - Formatting of cell
New to functions, 'If' isn't working for me	27 Oct 2006 10:14 GMT	1
I am trying to write my first function. Tha aim is to add an extra column and populate it with categories for each record. Hopefully the code below will help in understanding: Function undispatched_age_bucket(ByVal business, ByVal Paper_vs_Elec, ByVal
Ordinal Numbers	27 Oct 2006 08:43 GMT	12
Re: http://www.cpearson.com/excel/ordinal.htm =A1&IF(AND(MOD(A1,100)>=10,MOD(A1,100)<=14),"th", CHOOSE(MOD(A1,10)+1,"th","st","nd","rd","th","th","th","th","th","th")) I like the fact that this formula uses CHOOSE().
Excel Problems	27 Oct 2006 07:40 GMT	1
"i want to make a duplicate worksheet with the same data":
can macro edit text?	27 Oct 2006 07:38 GMT	7
I would like to convert a large number of e-mail addresses from one naming convention to another... ex "Jwilliams@yahoo.com" needs to become "williaj@aol.com". The finished product should consist of six lastname characters and 1 first initial. Can I use a macro for this? Any ...
Using COUNTIF to search for existence	27 Oct 2006 04:57 GMT	31
I want to use COUNTIF > 0 to determine if a value in column A exists in another column. This works fine for non-blank and non-zero cells. COUNTIF appears to handle a blank and a "0" the same way. If they exist in column A and a blank exists in another column, FALSE will be ...
How do I find and replace null values in Excel 2002 worksheets?	27 Oct 2006 04:53 GMT	5
I have thousands of empty cells which I would like to replace with zeros, but opening Find and Replace, clearing the Find field and entering 0 in the Replace field replaces zeros in larger numbers I don't want edited.
How to make IF function not change cell value?	27 Oct 2006 03:51 GMT	2
How do I make a IF function do this? IF(CELL1 = X ,CELL1,CELL2) The formula is located in CELL2. When the IF function is false, then I want the value in CELL2 to stay the same. I get a circular reference with this format.
SUM	27 Oct 2006 03:04 GMT	3
Everytime I type in the sum formula, it is exactly right, according to the help menu. When I get my answer, It is always zero, I do not have any numbers in my equation that are negative so I do not see how that is possible. I thought maybe I was typing it in wrong, but then I ...