Can I use the rate formula where there is step in the loan repayment PV = -1000 N = 3 years, £125 per year N = 7 year , £110 per year Rate = ??

In Excel 07, I have entered a date in a cell as a date format, 9/1/08. The Number format shows 'Date'. However, the cell displays 39692. After reviewing other...

I cannot get OUTLOOK to properly and easily send out pages from my workbooks. Since I wind up opening Yahoo, attaching the file and sending it, how do I...

Hi All, I've been breaking my head over the last 2 days but somehow can't get to the root of this. I'm working on a leave management solution for my office...

When I protect a worksheet in Excel 2007, the freeze pane option is not available (grayed out). How can I make the option available without removing...

When I try to insert column appiarenses window with text: to prevent possible loss of data, Microsoft Office Excel cannt shift nonblank cells off the...

I have a unique problem. I'm using office 2007 ( I also have access to 2003 ). I'm trying to format a list of names from Word to Excel. I don't mind...

How do I create a macro that allows me to sort alphabetically the names without losing the metrics associated with the name? I have multiple tabs that are...

Why would I ever need this function?

Hello, I really need help troubleshooting a formula. I am in Excel 2003. I am trying to count a column that has a different dates within a specific date...

Hi all, I was wondering whether there's any way for an add-in to define names (or something similar) that would be available from other workbooks. For...

I have a question and dont have the slightest idea on how to go about it. I have a cell G8 that will get text input to it. If G8 has text in it, then cell B8...

HI, I am looking for a function which returns a value by looking in to 2 dimensional table.For...

Hi I am trying to add only the negative numbers in a row of cells from sheet 1 and have the results shown in a single cell on sheet 3, but I keep only...

I'm working on a worksheet (with about 20 sheets). Yesterday my boss requested some checkboxes be added to the front (title) sheet. If 1" box is checked;...

We are having difficulty getting the prompt to appear to ask the user whether they want to update links in the spreadsheet or not. This was a feature used...

I have a formula that looks like this: =CONCATENATE("Placement of ",B7, " inch, ",ROUND(B9,2),"% lime stabilized subgrade") I need the cell references to...

=IF(AND(A311=A312,I311=I312),(J311=OTP,J312=REG),L311/1.5=L312) What I'm attempting to do… If the EmplID is the same on A2 and A3 and the and Pay dates are...

Howdy, I'm trying to solve a Binary integer non-linear programming with the mighty excel solver. The problems wants the optimal location for three facilities...