Hi All I'm having trouble with a couple of formulas and I think I've written them wrong?? First Formula: In cell CB183 the formula looks at...

I'm using E 2003. I have a need to use the XNPV and XIRR functions but they do not appear in my drop down list of functions. Are these functions that need...

This is directions for assignment- In cell A10 type =b8 to enter formula that references cell B8. Select range A10:A21 and then create Data table with a row...

I need a macro to collect the names of every worksheet in a workbook such that the names are in adjacent cells in one worksheet. The number of worksheets...

I have a cell with a very long formula in it. I am looking for a formula that will copy the values to another cell. Something like =valuesA1 Anyone know how to...

Can anyone help with the protection of part of an Excel worksheet (Excel 2003)whilst still allowing sorting and filtering of data? Individual users paste data...

I have a worksheet with Monday, March 15, 2010 in Cell A2. I'd like to have a formula that will put Tuesday, March 16, 2010 in the fifth cell after that (in...

How do you edit a drop down menu's location? -- Thanks, George

I am sure this question has been answered before but I am dizzy trying to sort through all of the other posts when I run a search. I have a spreadsheet...

Hi I would like to know if there is a formula/function to calculate the following: Start premium per month - eg $150 Premium increase per year - ...

=IF(AND(M26=7501,N26="A"),M26*G12,IF(AND(M26=7500,N26="B"),M26*F12),IF(AND(M26=7500,N26="C"),M26*E12),0) SO THAT I AM ABLE TO UNDERSTAND IF SALARY OF...

Good morning -- I'm shooting for a COUNTIF formula that will count text occurances across multiple worksheets. I can get the formula to work if the data is...

Hi All Is there a smarter way of doing this SUMPRODUCT formula? I'm finding different duration totals and multiplying the total by a different ratio for...

I need to add cells which only have reference to another eg: PNS Kilbirnie 2.0 NW Newtown 1.0 NW Island Bay 1.5 NW Metro 1.0 PNS Kilbirnie 1.0 eg: Need to...

Hey everyone. Excel 2003. I will frequently add up a range of cells (all dollar amounts that were typed in manually). When I add those numbers up with the...

Hi I need a formula for conditional accounts receivable aging analysis. Funds are provided to project managers in the field for operational expenses. Each...

I am pretty sure I ahve seen this but not 100%. How do you set a cell to run a timer like for a sporting event?

It appears Excel is very powerful at performing funtions on arrays, however, I simply want to multiply a whole column of numbers by one constant number, and...

I need to display information from another worksheet that would fill up a cell block the size of 50.28 x 532 (about 5 Columns wide and about 37 rows long) I...

I need a way to get text from a cell put into a function such that the text fills in the name of the worksheet to look for the data in. i.e. I want to look...