Two problems/questions.
A user has a spreadsheet with dates and times mixed in Col E e.g 01/0
(07:30-17:30), 02/07 (10:00-18:00). They appear to have the same forma
but assume it may change as a couple of users. It could be for 16 days.

I need to display the result of multiple IFs
if (J1>10<25) "1", if (j1>25<50), "2", if (j1>50), "3"-
Driving me mad...anybody help please?

Can someone help be understand why the data the the vlookupfunction is
returning is the value of the cell above the lookup up value.  e.g
lookup value is 3
table array is:

I need to multiply the time recorded (in hours:minutes) by the charging rate
(in currency) to get the total amount billed as follows:
Time Billed      Charge Out Rate    Amount Billed
01:00      £285   

I would like to use a subtotal cell from worksheet 1 and have the total cell
in worksheet 2 look at that cell and add it in to worksheet 2 cell total and
so on up to around twelve worksheets in the same workbook.

I'm trying to add the number of cells that contain a series of numbers. I.E.
From E2:E24 add the number of cells containing 100% and total in E26. for the
same range count the number of cells containing numbers from 90% - 99% in
cell E27.

I'm using the =DATE(YEAR(B32),MONTH(B32)+1,DAY(B32)) where B32 is the prior
date.  This works fine when the prior month's day is not the last day of the
month.  If it is the last day, the results are a little goofy.  For example,
adding one month to 6/30/06 produces 7/30/06 ...

Does anyone know why when I enter =SUM(A1.22) Excel 2003 automatically
changes it to   =SUM(A1:22)

my problem seems pretty simple. Let's say I have a sheet with 3 columns:
first name, last name and age. I enable the "autofilter" function to decide
if I want to sort by first name or last name. Somewhere on another sheet I
make a reference to someone's age. Let's say that I ...

I have a sheet that has conditional formatting on it.  My problem is when
there should be a 0 it will not list it as a 0 but a blank.  When there is a
blank cell it is shown as blank.  Is there a way without messing up or having
to redo my conditioanl formatting when I want a 0 ...

I am using autofilter and each time I switch to the next entry I need to
capture the last value in a certain column to use as part of a new formula.  
Let's suppose my filter shows me my headings in row one, data in rows 11-20,
and then first blank row (row 3100) below all the ...

I am trying to create a formula where if L2=yes then the values is 2, if no
then it is 0. I need to have 4 colums set up this way (l,N,P &R except P&R
value is 1 instead of 2) and the answer of all 4 combined in once cell. How
do I do that?

Received a spreadsheet with these annoying pop up boxes that the boxes stay
up until I move the cursor to an unaffected cell.  Appears to be attached to
a range of individual cells.  Can move the comment, note or ? anywhere on the
spreadsheet, not outside of spreadsheet.

Hello my name is Ronnie. I am running a Premiership Predictascore gam
this football season and want to add the Premiership table to th
workbook, so that once I have inputted the scores for that week int
the spreadsheet, it automatically puts the information into th

I want to find out the number of rows where the more than one column meets
criteria set in another cell.
Eg:
Column A is Name