Can anyone tell me the definition of the word Formula, please..

I have two sheets in my Excel 2007 spreadsheet---Sheet 2 is a list of all courses with several columns, but two in particular (Column 1 is COURSE ID and...

i have been trying to find a way to round the value of a quotient to specific decimal places but I keep getting errors. Is there a way to round quotients to...

Hi, I'm trying to create spreadsheet that utilizes data in two different rows. The spreadsheet is meant to track types of accounts assigned to a number of...

I know if I ask for the percentage of =G44/H44 and both columns contain a 0, or H44 contains a 0, Excel will return a #DIV/0! error. Is there anyway to...

I'm trying to keep the cell colour from the original worksheet when I link the data to another worksheet, the colour is added manually and not...

I know this is probably simple but I am new to excel and have been going crazy here. I am doing spread sheet for feedback on jobs I have quoted. There is...

Hi I have a Macro which is run on a Monthly Basis to clear and move fields etc for new months data. This works well, except I would like this is either...

Hi XP Home MS Ofiice 2003 First may I apologies to T. Valko(unable to send my file to him/her)...see "complex array" Now my problem:

I have a spreadsheet that has the names of employees, customer ratings and customer satisfaction. I need to be able to count the number of times that certain...

Is this what you are looking for, entered in H9: =if(and(sheet1!b9="A",sheet1!c9="B"),"C","whatever you want when not true") Regards, Fred "susanmck"...

We recently upgraded from Microsoft Office 2000 to 2007. Prior to the upgrade each department would access a spreadsheet that would load data from a common ...

Is it possible to select only the cells of a certain colour or cells without a colour when I link a range of cells from one worksheet to another? Many thanks

Hello, I am trying to use the =SUMPRODUCT formula but it does not seem to be working. Not sure what I am doing wrong. Here is an example of the...

Hi, I am trying to find the process of taking a spreadsheet (worksheet) and having the system randomly select 10% of items $10,000 (or can be 10.000)....

I want to count all the entries in column N that occurred between a range of dates specified in the other criteria. The dates are obviously in column B. I...

Once you have applied conditional formatting, is it possible to count the number of cells that turn the different colours?

I'm trying to use the match function with a nested if statement. Is this possible? My table looks like the following....

i need a fomula that will search down a specified cells in a column... look at the words in each cell and then display the text i want. for instance... I...

The numbers represent rounds. So a name will go with a round (number) but some names know more than one round. Name a 1 name b 2 name c ...