Functions

#NAME? Error With User Defined Functions
Excel 2007 I have a problem that has been driving me nuts. I created a code module and have pasted a couple of user defined functions into the module. When I am entering my formula into a cell and I start typing the name of the function, I see that the function is listed in the drop-down list of functions. ... 6 Jan 2010 09:49

Countif Formula
I imagine this is a simple question, but I would like to do something like the formula below, but I would like to do it for a range within 15 minutes (+15 or -15 of 0). =COUNTIF('Data (2)'!$Y$2:$Y$1508,">30") Thanks ... 29 Dec 2009 18:38

Product Formula
Hi, I have a column of quarterly returns which I wish to calculate longer term returns from. My problem is that the list will continue to expand over time (I will insert a row at the bottom every quarter) and the calculations should always be over the latest periods (e.g. 1 year/3 year etc). I have tried u... 29 Dec 2009 11:56

Error with Copy function
Hi, I'm trying to copy data from workbook A to workbook B. However, whenever I select workbook B, the Paste function is blur, which means I can not paste it. If I create a new workbook , then I can paste the data there. In workbook B, I created a macro to open workbook A. Pls help me how to fix this. Ma... 29 Dec 2009 07:30

formula for excel sheet.
Hi, I want to use a formula in excel as below described. i want a formula value in Cell A2.b In Cell A1 is value say if it is $ 500 or above then the A2 should be 75% of A1, if A2 is between 200 to 500 then A2 should be 50%, if A1 is below 200 then A2 should be 25% of A1, so please help me out - thanks in ... 29 Dec 2009 10:49

In Excel can sheet tabs be placed along a side margin?
Instead of having tables along the bottom of a sheet, I want to put them down the right hand margin. Is this possible in Excel? ... 29 Dec 2009 06:26

hello please help i really should have payed more attention in class
ok i want to do some book keeping. i buy and sell stuff. i want a to be what i bought like an item i want b to be what i paid to get the item i want c to be time and gas put into getting item i want d to be additional costs like repair or parts added. i want e to be totals of all expenses basically add b+c+d i w... 29 Dec 2009 01:04

Count Consecutive string of same number
Hi, I would like to find a formula that will give me the largest consecutive sting of numbers out of a list. Here is an example of the list (A1:A10000): this answer is 3. A 1 1 blank 1 blank 1 1 1 Thanks! ... 28 Dec 2009 22:54

subtracting ranges
In cell p94, I tried the formula =sum(d94:e94)-sum(f94:o94) and it does not give me an answer in p94; can anyone help? ... 28 Dec 2009 17:24

Same problem.
I've had the same problem with one of my spread sheets. The file is not protected and I can open the format cells dialog box on either side of the effected cells. I'm completely stumped as to why I cannot open the dialog box and multiple google searches have not helped. Ms-Exl-Learner wrote: Check whether th... 28 Dec 2009 12:58