I am trying to write a formula by which I could be able to handle 10 conditions in total. Please help me out as Ms Excel can not handle more than 7 nested ifs....

MIN value question: I have a spread sheet for grades. I have set up two cells one to give me the MIN value and the other to give me the MAX value. That way I...

To mark specific records for merging, you could add a column to your table in Excel, and use an IF formula. For example, =IF(A2="","X","") would return an if...

Hi, I want to use CUMPRINC and CUMIPMT in an amortization for a loan that includes a balloon payment. CUMPRINC handles this perfectly when I subtract the...

Hi all, Say I have a spreadsheet listed as follows: A1 = 03/31/05 A2 = $5.00 B1 = 03/31/05 B2 = $10.00

I have 5 categories that I need to sum but it is on another tab. I can't remember how to use the Sumif and vlookup formula together. Product A = 100 Product...

I have been having serious trouble trying to sort this out. It is a little complicated and I will score major points with my supervisor if I can sort this...

Have a golf card on a 2002 Excel sheet wanting to print many cards after reading names and handicap from an 2002 Excel sheet. Can not find a way of getting...

how do I convert grams to pounds? is there a function for this? I use Excel 97. Thanks

I have the following worksheet setup: Column A = Origin Column C = Destination Column E = Airline Cell A2: DTW Cell C2: IAH Cell E2: CO Cell...

Hello. I have a function that allows me to calculate the length of time between...

I want to do a SUMIF that will add amounts from either column C, D or E based on the following criteria: For each cell in the range F2:F200, if there is a "y"...

I have a datasource worksheet and output work sheets. I want to want to link a cell in datasource work sheet on the outputwork sheets base on a formula. For...

Does anyone know if there is a way to change the number formatting from General to Number in one shot? I have an entire column that is in general formatting,...

I need to create a macro for unpaid rent with gray backgound red text and border and in bold style unpaid rent is listed as no in worksheet in paid colum.I...

I have 3 cells I need to merge into one. One of the cells is a number anywhere from 1-16 or more. What I need is for the number in this cells to always be...

I have a large spreadhsheet with data I've manually copied/pasted from various sources including web pages. As I am trying to do things like import to Mysql...

Is it possible to have a note attached to a phrase rather than a cell? So where ever that phrase may be duplicated within a worksheet, it will carry the same...

Hi: Cell designations are H8:H51. I used your entire formula. But didn't understand where you got the "hhmm" designation. My military-time cell examples a...

Does Excel have a function that will allow me to count only the data range for a specific title when there is more than one data range in the same column? I am...