I used the [hh]:mm number format to add hours and minutes. Is there a way to
display the result of 46:40 as 46 hours and 40 minutes

I would like to set up a drop down list where the user sees text descriptors
but the value of the cell is a numerical value.
Say I have three possible types of wages that I have placed into the named
range "rate":

Hello,
I have this formula and it's very long.  Below is a copy of it
=IF(J_Z_1=CODECOL,INDEX(FINAL_ALL,MATCH(A2,'Final Merge Fields'!A:A,0),MATCH
("Code",FINAL_1,0)),"")

Just curious if there is a function you can use to put in an IF
eg
IF (ISERROR(A1),blah,blah)

I setup 2 dependent drop-down list using the validation and INDIRECT function
in EXCEL. Everything works fine when I have 2 name ranges that refer to
actual range. 1 cell with validation pointing to NAME1 and the other cell
would have =INDIRECT(cell) in the value box. However, ...

I have a situation where I have been told the only way to get my data to
work with Access is to take EVERY value (some 2,000) in each cell, and wrap a
double quote around ANY of the values that reside in the cell.
So the value 54712332 would need to look like "54712332".

If I have two rows of numbers...
    5     10     15     20     25     30     35     40     45     50
    1     16     23     18     64     28     46     72     18     26
Is there a formula I can insert, in another cell elsewhere on the sheet,

This problem has a bit of history, but I will cut it down to the bare
bones. I have a workbook that starts with three sheets called Semester
1, Semester Template, and Totals. I have a macro on Totals that creates
a sheet for the next semester before Semester Template, in this case ...

I am having trouble with the COUNTIF function.  I am searching for the
frequency of occurence for a name in a range of cells (not in a row or
left-most column).  The name I am searching for is the result of a cell that
has been concatenated from other data.

I have an investment (property) that I want to know when I will break even on
(and start making a profit)?  For example:
Property Value $80,000
Appreciation Rate 8%

The IF() function is generally used to test the value in a cell.  Is
there any way to get the IF() function (or some other function) to
test the formula in a cell?
For example, the formula in Cell E1 might be:

Heloo
how i get the value of active cell into other cell automatically?????

Hello. I'm trying and trying to use a worksheet function in a macro. What Im
trying
to do is to calculate the number of empty cells in a range of cells in the
worksheet

Hi. I have been trying to get my head around some formulas and it has been
driving me crazy (yea, one of them beginners, me!!)
Basically, I need to add numbers from a range of cells, but do not want the
result to exceed a certain value. For example, I want the sum of cells A1,

Is it possible to introduce more than 3 conditions (via conditional
formatting) onto a single spreadsheet?
I have a spreadsheet with 9 columns - the first is for name, then 1st
choice, 2nd choice etc etc...up to 8th choice.  There are 8 different things