Functions

Comment Edit
I have a spreadsheet with a comments attached and I cannot edit any of the comments. Thank you for you help in advance, Kathy ... 25 Feb 2010 10:18

Formula refers to empty cells even when cells contains data
I have a worksheet with link to external data source. The option is enabled to ask me to enable auto refresh or disable auto refresh. I have used 'Sumif' and 'vlookup' function to calculate certain values. Now, even when the data is available in cells, the error checking option shows me a little green flag wi... 25 Feb 2010 14:51

Thank you
Hi! Bernie Im so pleased with help, I also tried to some other tricks =IF(B3>=E3,"ontime", IF(B3<=E3,"late")) although if E3 is 0:00 and B3 is 0:00 instead of showing 0:00 it says ontime. Regards Anathi Bernie Deitrick wrote: Anathi,Somethng like=IF(B2>A2,"Late","On Time")Where B2 has the actual... 25 Feb 2010 03:42

Reverse string on multiply cells
Hi, I am using the formula for reversing string I have got from the forum but it works on a single cell. How can use it on a multiply cells. For example: suppose I have a list of names in cells A1:A10 and I want to reverse them to cells B1:B10. Using Excel 2003, Thanks, Amnon ... 25 Feb 2010 20:31

how to calculate billable rate using base rate and percentage
I have a billable rate of $70 with a mark up percentage of 17.65%. How do I calculate the base rate? ... 28 Feb 2010 07:49

Cell formula that will give back the address of the cursor?
There HAS to be a formula so that I need NOT go thru VBA to obtain the current position of the cell pointer! Has to be! This CAN'T be new? Is there anyway to access the 'Name Box"? ... 24 Feb 2010 22:13

Finding the cell loacation that matches a specific value in a
Thank you to both it works. "Rick Rothstein" wrote: This maybe... =MATCH(3256,A1:A100,0) Although I would probably use a cell reference in place of the hard-coded 3256 value. -- Rick (MVP - Excel) "Zuo" <Zuo(a)discussions.microsoft.com> wrote in message news:F6225750-C5... 24 Feb 2010 17:45

Finding the cell loacation that matches a specific value in a rang
Hi, I have a list of references in column A going from A3:A240. I need a formula that can find a specific reference within that range and give me back the location of the reference. Example: A1 7569 A2 1245 A3 3256 A4 7895 If I input 3256 it needs to return either A3 or 3. Thanks, ZUO ... 24 Feb 2010 17:44

formula range doesn't update for new rows
I have a workbook with multiple sheets. Some sheets contain imported data and some contain sumproduct formulas referencing the data. When the data is refreshed, the formulas all return #N/A values. The range in the formula is not being updated to reflect the new rows that have been added when the data sheets... 24 Feb 2010 18:53

Multiple lists in a cell
Is it possible to have a list range in one cell based on the inputed information in that cell? IE, I have a packing list for 3 different products, and 3 different master lists. On the 1st list, I have added in list form in one cell the 3 different lists I could possibly generate. Is it possible to change a l... 24 Feb 2010 14:18