I am using Data Validation / dropdown to allow a user to select either a static entry or a calculated one. There is a line of products a1=apple b1=banana...

I am trying to put in a worksheet, those things that look like comments but instantly show up when the cell is highlighted. Whatever the name of this function...

I have been on here previously and successfully found an answer to a query about the IF function. Unfortunately it only works partially and I can't find my...

I can't figure out how to use the Insert Function dialog to create nested functions in 2007. This is something you could do in earlier versions though it...

'End' message has appeared without my intention or knowledge, and prevents me from adding further items to a spredsheet. How can I get rid of it?

I have a sheet with 3 columns Value Status Type I want to be able to get total values from these columns based on a combination of Status and Type. If...

I'm an Office 2003 Purchaser, and I love Excel. The problem is that I cannot add-in each of the available add-ins. I don't know why. I have certification...

After requesting the updating of links from closed source documents, the cells in the destination workbook are returning #VALUE!. Once the source documents are...

I need to create a drop down list, that changes selections, based on the value of a different cell. For instance, if the value in the key cell is Apples,...

Hi all, I am unfamiliar with nested IF statements. I want to have a formula evaluate the following: b1=.005, b2 could =-.004 or b2 could =.004 If b1 is ...

How many functions can be nested together? Currently, my function looks like this: =IF('Dec 11'!I33 ="P",'Dec 11'!$O$1,IF('Dec 18'! I33="P",'Dec...

I want to format the font color in cell G82 by checking the value in cell D82. The value in cell D82 can be either blank, CAER followed by digits or COR...

I am generating charts from PivotTable reports. The tables take thier data from a field that contains a =median() formula. The formula often gives deicmal...

Hi Guys its me again sorry. Below is the function and the results obtained. I have changed the cell format to all sorts with no effect. Hope someone can...

Hi Folks the function below works in excel 2007 but not in 2003. =IFERROR(LOOKUP('HDU Roster'!$C$9,{7,8,11,1330,1430,2245},{8,8,8,8,8,8}),0) The file is saved...

Hi Folks hope someone can help. One of you guys usually can. So thanks in advance The following formula provides unexpected results. =IF(ISERROR(LOOKUP('Hotel...

Hi Folks hope someone can help. One of you guys usually can. So thanks in advance The following formula provides unexpected results. =IF(ISERROR(LOOKUP('Hotel...

Hi i have a spreadsheet with multiple workbooks. on one workbook data is entered using lists. (the data for the Lists is on a workbook called "lists") when...

Hi i have a spreadsheet that uses this lookup table that lives on a sheet called "Times". on the working sheet if CHC is entered then Am is displayed in the...

Hi using excel 2007 looking up values and need to sum the results lookup...