Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / January 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Can't Access Add-Ins23 Jan 2008 09:55 GMT1
Ijust upgraded from Office 2003 to 2007. I had in Excel an add-in that
Federal Express had given me (that opened upon launching Excel) which would
allow me to bulk track large sets of numbers in a sheet.
I can see in Excel Options that the add-in is still there and loaded, but I
Modify a UDF please?23 Jan 2008 09:40 GMT2
Could this be slightly modified please:
Function ConCatRange(CellBlock As Range) As String
Dim Cell As Range
Dim sbuf As String
How to delete blank worksheets23 Jan 2008 09:35 GMT1
My Excel 2007 Workbooks always have a blank Worksheet at the end which I am
unble to delete.
How do I prevent 2007 Workbooks from having this unwanted blank Worksheet
and how do I delete it when it appears?
I want to count the cell if contains 111 or 111123 Jan 2008 08:59 GMT2
I cant get this one, must have a comma in the wrong place.
FORMULA23 Jan 2008 08:53 GMT3
DEAR FRIENDS,
I WANT TO ASSIGN NUMERIC VALUE TO ALPHABET
FOR EXP.
A=1,B=3,C=5 AND SO ON UP TO Z AND THE RESULT SHOULD BE STORED IN THE NEXT ROW
Referencing Cells23 Jan 2008 08:40 GMT1
I have several columns with dates and text.  For example:
1A text
1B date
1C date
Formula Help23 Jan 2008 08:39 GMT1
I need to set up a formula that results in an outcome based on the below chart.
If the cell result is less than or equal to  minus 2.50 the outcome is $0.  
If the cell result is wihin the range below the outcome is the corresponding
dollar amount.
Date changes mysteriously23 Jan 2008 06:59 GMT2
I am having trouble with cell referencing in a workbook.  I have it set up so
that I enter the date on the first sheet and then reference that cell on the
following worksheets. This works on some of the worksheets but not on others.
For some I get a #VALUE and for some it ...
countif with variabel criteria?23 Jan 2008 06:57 GMT2
I'm blocked on a most likely very simple issue: I'm trying to have the
criteria in the countif function refer to a cell, so that the formula gives a
different result when that cell value is changed.  I'm trying to compare
times in the [hh]:mm:ss format, and the 1904 date system ...
Editing an Office 2003 Document using Office 200723 Jan 2008 06:49 GMT3
One of our employees has Office 2007 installed on his laptop and the rest of
us use office 2003.  Whenever we e-mail him a document he states that he can
not edit that document.  Can someone please help with this?
EXCEL 200323 Jan 2008 06:38 GMT1
If I want  39 = 7.0
how would I put in the formula
I am trying to use it as Reading score conversion
time seperation23 Jan 2008 06:34 GMT1
Hi Im getting knocked about with this one and sure could use assistance from
someone in the know>>>
I am applying the following formula
=IF(C12>$W$5,(C12-$W$5)*24,IF(C12<$Y$5,($Y$5-C12)*24,"0")) to work shifts
Multiple Logical Functions in one Formula23 Jan 2008 06:24 GMT1
How can we use multiple logical functions into one formula. We have 2 cells
with numerical values which are a result of various cells in the sheet. We
want the 3rd cell to be populated with "Excellent","Good" and "Needs
Improvement" if various conditions are fullfilled according ...
This should be easy, but can't find an answer...requesting your in23 Jan 2008 06:02 GMT1
Here is my spreadsheet:
            ---Date Range---       
Conversion Date    Descr1    Begin Date    End Date    Descr
10/25/94        ?    02/05/96    03/03/96    FY1997P1
Replace the Find Function with a formula23 Jan 2008 04:46 GMT1
Is it possible to create a formula that is like the find function. I would
like the user to be able to type the number or name of an item they are
looking for and it will take them to the cell that has that name or number in
it.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.