How do i create a formula like this
=SUM((AE3={"O","1","2","3"})*{empty,30,60,90})
The final format I want to accomplish is: AD=AA3+AE3 where AE3 is empty
leave AD3 empty

Hello,
I would be very much greatful if any one can give me a solution to the
problem. My problem is what is the equation to change the date value (for
example: 39124) to a date ( for example: 11-Feb-07)?

I would be very greatful if anyone can give me a solution to my problem. My
problem is: what is the formula to convert the date vale (for example:39124)
to date ( for example: 11-Feb-07)?

Hi Friends,
For below code, i need to create a macro which copy the URL from a cell and
pass on to the web query URL written in another macro:
ActiveSheet.QueryTables.Add(Connection:= _

I'am wanting to write a formula that would sum a colum of numbers and then
round those numbers up or down to the hole dollar.
         A          B
1      22.10    45.76

Using =@sum(a1:a3) or any formula will automatically generate an EMAIL
hyperlink.  
We also use Infopath.  When you are in a rich text format control, and you
type  =@sum(a1:a3) and hit enter after the closing paragraph character, it

I was always trying to sort the list of Medical Records to be retrieved from
filing shelves which is arranged by Termianl Digit Filing system. In our
hospital, each patient has a 7 digit unit number and this unit number is
devided into two sections of primary number and secondary ...

Hi, I hope that someone can help me I am trying to figure out how to make a
address database with account numbers for my customers,  I have all my
Address and account numbers in one worksheet an then on the front worksheet I
would like to be able to find a customer in the database ...

I have 26,000 cells that I need to extract just the first 3 digits of the
cell.  For example, the cell reads AAG122345 and I need a new cell that only
reads "AAG".  How can I do this?

Using EXCEL 2007 ........I have a column of data that has 5 blank spaces in
the first 5 positions.  I would like to remove these blank spaces.  When I
clicked on the Fx icon it placed an = sign next to the Fx icon and launches
me into a formula wizard screen.   I'm trying to ...

I have a speadsheet that shows the following:
Name
Position
Tenure

=IF(OR(SCHEDULE!B11<>"OFF",SCHEDULE!B11<>"PTO"),"8","0")
Whats wrong with my formula? I would like it post an 8 when B11 on the
SCHEDULE workbook shows anything other than OFF or PTO, and a 0 otherwise. It
works for the OFF, but not for the PTO.

Using the formula =CONCATENATE(B369,": ",C369) in cell D369, I'm able to
merge the text in the referenced cells. However, using the instruction
provided in Excel help and the demo video on Excel support site I'm unable to
extend the concetenation to the remainder of the column.

I have two spreadsheets.
The first sheet contains 1000 entries in column A and column B.  Column A
reads "ABC".  Column B reads "All Brands Commercial" in row 1.  In row two it
might say "ABD" in column A and "All Brands Drury" in column B.

I have a column in my Excel spreadsheet that contains times. All the times
are for one day and always will be for one day only. I'm trying to subtotal
a particular column by Hour. The column has data in the following format:
0:00:31 (representing hour:minute:second)