Does anyone know the conceptual difference between IPMT and ISPMT... why do they calculate different numbers. thanks

I have a spreadsheet to maintain truck weights. If the weighmaster enters a Gross, and a Secondary Gross, the spreadsheet should calculate the amount of...

Does anyone know how to generate a unique card number based on a previously existing number? I'm trying to create a 16 digit Check number by only given the...

I'm trying to check for duplicates excluding blank cells across a range A3:I3 I've looked at Chip Pearson's site and tried adapting the formula...

We have linked cells in multiple worksheets (one workbook) that do not like it when we sort. Is there a suggestion about how to have linked cells lock even...

Hello from Steved Can someone please give me a formula to run the below. EASTERDATE date of Easter Sunday for a given year Thankyou.

I am working on a formula to do candlestick charting manually. I have a number in cell A1. I want to compare that number to 4 numbers in 4 colummns OPEN HIGH...

i have found a bug in 2007 excel relating to pivottables? who is interested in hearing about it? who do i send it to? ---------------- This post is a...

I intend to enter a header/footer onto a worksheet, using Excel2002 on a Sony laptop. A "No printers are installed. Click to Settings to install a...

I have 3 columns of data. Col 1 is either the number 1 (to indicate that the person lsited on that row has signed up for volunteer work) or the number 2...

I have a spreadsheet with several hundred dates in diffferect cells. The dates are typed in as "01/01/2003" but show up in the spreadsheet as a five digit...

Cell A contains a name in the format 'first initial last'. I want to create cells from this: 'first' 'initial' and 'last'. Are there formulas for the 3 cells...

I have two columns of dates (one titled "Start" the other "Finished"). The dates are unique, and the Start date is always smaller (less than) the Finish date. ...

Is there a way I can "easily" convert my .xls document to .qpw for Quattro Pro 10? It is a spreadsheet containing about 8-9 worksheets. There is an option...

Can I put the custom view toolbar list box in a worksheet? I tried customize and dragging the option box on the worksheet but it didn't work. Is there a way...

I have been able to use formulas for mortgage payments and amortization. But I can't find one that will incorporate an early payoff on a loan. And I don't know...

It has been a long time since I asked this question to this problem. The answer was simple but I forgot what it was. I have a template spreadsheet I created...

I WANT TO BE ABLE TO TYPE 6 DIGIT NO. EG 010101 AND EXCEL CHANGE IT TO 01/01/01 HOW CAN I DO THIS SIMPLY THANKYOU

Dear all i am trying to make a formula or to find a way to solve the following problem a have in a call A1 a number e.g 5 i want to find a way that each time...