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 / August 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
V-Lookuo15 Aug 2005 18:40 GMT2
I have a V-Lookup that contains email addresses.  But when it transfers over
to the other sheet, the link does not work.  Is that possible to make happen?
Count values in a cell15 Aug 2005 18:03 GMT2
I need a formula to do the following.
I have a list:
A
B
Delete text while numbers remain intact15 Aug 2005 17:32 GMT2
I need to find a quick way to delete or move all letter data from a range of
cells while leaving the number data intact.  I need to be able to sort my
spreadsheet by the numbers in each cell, not by the letters.  I could go
through each cell and delete the letters manually, but ...
NUF schedule15 Aug 2005 17:04 GMT1
I would like to improve the schedule attached.
http://cjoint.com/?ipkzvZlI8y
It is the calculation of the non utilisation fee (CCNU) on a revolving loan
(C)
Question about {}15 Aug 2005 16:59 GMT2
Dear Sirs
I saw some functions starting with{ and ending with }
What is used for? Can you give me some hints for using that things?
counting in pivot table15 Aug 2005 16:58 GMT14
I have the data source like below:
product     customer     quantity
1              A                1000
2              A                1000
Macro to copy range of formulas to equal data lines15 Aug 2005 16:38 GMT2
I would like to have a macro to copy a range of formulas in row 2 down for
all lines of input in an adjacent range.  For example:
Input                                        Formula
Row 2                    Cell X2    Cell Y2
PorductLog15 Aug 2005 14:55 GMT2
How do I can typing this formula on excel?
http://functions.wolfram.com/ElementaryFunctions/ProductLog2/06/01/
Does'nt matter wha
--
AND function in Excel15 Aug 2005 14:47 GMT4
Can someone help me with a logic test using the AND function.
IF(A2=A3,A10 AND D2=D3,C5)
The above is what I am trying to achieve, can someone show me how to do it
correctly.
How to do matrix operation with complex number elements in Excel15 Aug 2005 14:26 GMT1
Would like to use Analysis tool pack function , Matrix multiplication with
elements as complex numbers.
VLookup Problems15 Aug 2005 13:54 GMT2
I'm sure I've done this before but I can't remember how.
I have a list with times by 15 minute intervals, I want to populat
this with call volumes from another list, however it does not retur
the intervals with nil value.  So for example, I have not return fo
excel date problem15 Aug 2005 13:26 GMT2
actually what i need is,in one excel cell i will be entering 15/8/05 and the
next cell i want to get the value as 30/8/06 ,that means next year same month
with end of month date  
Can wildcards be used in the Logic Test of an Excel "IF" function?15 Aug 2005 13:25 GMT3
Currently, I'm using seven nested "IF" functions to return one of three
account numbers.  Is it possible to use a wildcard in the Logic Test to
decrease the formula to three nested "IF" functions? If so, how? If not, any
suggestions?
HD I build funct @if cell=AorBorC then  ...else if cell=DorE then15 Aug 2005 13:16 GMT8
Does anyone know how to build a formula as follows
if(a4='apple' or 'pear' or 'plum',   then 'fruit'   else
if(a4='carrot' or 'bean',   then 'veg'   else
if(a4='bun' or 'cake' or 'donut'   then 'pastry'   else a4)))
Date & Time problem15 Aug 2005 13:14 GMT2
I'm having trouble adding dates and times.  
I want to be able to create a schedule based on a few inputs in th
first column: start date, start time and length.  Length will also b
input manually in each column.  Each column afterwards would calculat
 
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.