EXCEL 2003- How can I modify "=IF((OR(C10="",B7="")),0,IF((C10B7),((C10-B7)*24)+24,(C10-B7)*24))" to add up total hours over multiple days with a start time...

I have a 2 worksheets. Worksheet 1 gets data from an external source and refreshes every 10 minutes. Worksheet 2 extracts data from sheet 1 using formulas....

Help required to solve a pain of an issue (and save what little hair I have left) I have a very large worksheet containing monthly sales data for...

I am not sure you can use relative for worksheet as you describe. I suggest you just do a find and replace.Sheet1 --Sheet2 As you indicated if there is a...

I'm using Excel 2007 and I'm trying to calculate XNPV for a certain array within VBA. Within Excel, the XNPV function asks for 3 arguments:...

I entered a number on my worksheet using the $ function. I should have used the format, cell, currency command. I have enter numbers like $665 and now want...

When I subtotal at 3rd level the subtotal is not going to the bottom of the data, although the tick box is clicked. I have data by company, branch,...

I would like to be able to alarm the fact that a date has not been entered into the cell before a set date. IE: We sent a Drawing for approval on 10-nov-07....

In Excel .csv file, I format cell as text enter 001 and save. Reopen and everything is reformatted as general and cell shows 1. Can this be fixed?

How do you change the last cell in your worksheet? I want to reassign the last cell it takes me to when I choose CTRL+END.

I am entering a differnt value into a cell that is already part of a formula in another cell. Before i would change that value and the sum of the formula...

I have a problem I have not found in any FAQs. I use three different spread sheets in my daily record keeping. On one I have a problem with font color. I am...

I have a (long) list of spectral data. It consists of 1 column of time increments, and 1 column of intensity values. I am trying to find the maximum for each...

would I use excel calculate totals of my daily cost codes as there inputed

I want to track my DVD collection but I only need a list of titles, sorted alphabetically. Catalogue software wants to store numerous other attributes for...

If G3 is a date and F3 is equal to IF(G3TODAY()-2,"OPEN",IF(G3TODAY()-3,"PAST DUE")) How do I return "n/a" to F3 if G3 is left blank?

Can I use a conditional format to highlight a entire row, say A1:A20 when cell value in A21 equals the text "Open" for one color and set another row color...

I have a formula that I am using to project dates. Cell equals another cell plus 3 (formated as dates). i.e In cell F4 formula is =F3+3 But if that date...

I have a spreadsheet that has location id's merged as 3 cells to create a row of info. But then in one column (F) I have 3 cells in the row not merged. I...

I have one column with data down the first 50 rows. I need to insert 3 new rows for each of the existing rows of data. I failed an attemp using a formula...