Hi, I am trying to write a formula within the conditional formatting dialog box. I have a column with dates and I wont the cell to become red whenever the date...

I have set up a purchase order workbook. What I want to do is have the shipping and handling cell calculate 3% of the subtotal or $10.00 (there is a 10 dollar...

this is trivial example 1-May 1 1-May 2 1-May 3 2-May 4 3-May 5 the formula =LOOKUP(A1,A1:A10,B1:B10) gives 3 and not 1 or 2. why?

I am trying to create a formula that looks at two variables on Sheet 1 and returns a value from one of two columns on Sheet 3. Essentially, what I'd like it...

Help. I am importing .xls information into a custom / proprietary contact manager system. Problem is the Excel address information comes in 2 columns 1) the...

How to perform calculations using time as arguments? E.g. "F1-F2" works fine where both cells contain values with (h:mm) format, but "F1-8:00" returns an...

I am working out rosters over a three week period for 10 staff, I need to calculate in time worked each day in hours & minutes (less meal breaks if applicable)...

Greetings, Jim Rech's code works great for this, see: http://groups.google.com/groups?threadm=e1%241uzL1BHA.1784%40tkmsftngp05 But is it possible to trigger...

I posted this once before but never actually saw it posted, so im trying this again. My problem is as follows... I am trying to track weekly sales day by day...

OK, I was able to use the indirect function to help. I'm half of the way to where I want to be. In A1, I hard coded Sheet1 for the worksheet name. Then, in...

I have a spreadsheet that lists each job we have on continuous rows. I highlight in yellow the rows that contain the jobs that we have not recieved payment...

I have a column of data which is town names, and I want to count the number of each town name that occurs in the column. I am using the function COUNTIF, and...

I used the Lookup Wizard to create a formula which is =INDEX('Penalty Table'!$A$7:$F$26, MATCH(1,'Penalty Table'!$A$7:$A$26,), MATCH(2003,'Penalty...

I have created a spreedsheet that I wish to distribute but I want to protect the contents. I have already used the protect option but I want more.

I'm trying to make a function for a test evaluation. I have 3 columns with Tests, one with Exam and another one with the final Score. Now, in the final column...

I have a table that has Temps along the x axis and Altitude down the Y axis. Whats a formula that would display the value in the cell where a given Alt value...

Hello I have a scorecard for the Eurovision Song Contest tomorrow. This scores 24 countries (listed in A1:A24), giving each country a point score between...

I am trying to figure out a way to formulate or format a column to reflect particular currencies based on that text located in another column (for example, if...

I have in column "T" 1800 rows with numbers , there are blank cells separating the rows in different sequences. I need to find the sum of each sequence , from...

I'm not too familiar with VB scripts in Excel and I received one that I want to run, but please forgive my ignorance, how to I run it? Where to I input the...