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
web page numbers21 Aug 2005 06:52 GMT3
when i down load my visa statement from the internet how can i add the numbers.
when i use the =sum to add it i only get 0
The numbers are in the right colum, but will not add up.
IF RESULT OF FORMULA IS 0 WRITE EXTIMATOR21 Aug 2005 06:08 GMT1
A10 cell that is equal that D10 cell, If D10 Cell is blank A Cell will be
writen Estimator.
VLOOKUP using a cell calculated with NOW returns Error21 Aug 2005 03:22 GMT2
I am calculating the present age of people, then by their age, I am looking
them up in a rate chart based on their age.
I calculate their age by NOW-D.O.B. which works fine. (see actual cell
contents below)
Nesting excel greater than 7 arguments21 Aug 2005 02:22 GMT9
I'm trying to nest greater than 7 arguments, based on a variable rate
structure. For example, there are 8 different age catories, and 9 different
rates... so depending on the person's age, i need to use a different rate.  I
have successfully nested the maximum, but it leaves me ...
totals from a tabel21 Aug 2005 00:05 GMT1
I have a tabel that looks like this
                              Stick        Ball    Club    
                               12           2        4
Jones       16               x                      x
function CELL() to return the formula in the referenced cell20 Aug 2005 22:25 GMT3
Is there a function that returns the formula in a cell?
Example:
Cell C3 contains the formula    =Rates!D4
I need a formula that returns this in such a format that I can convert the
I am trying to set a letter grade for my students, HELP20 Aug 2005 21:34 GMT5
I followed the formula that help suggested, it was a IF statement, one way it
turns out false, the other way the only grade that will show is an A.  The
formula is as follows:
=IF(H24<89, "A", IF(H24<79,"B", IF(H24<69, "C","F"))).  When I try this it
VLOOKUP, INDEX, MATCH... What to choose20 Aug 2005 19:15 GMT3
Here is table on sheet1
   A              B                   C             D            E          
  F              G
1Order Nr    Cust PO    Cust Name    Order Date    Post Code    Volume    Price/Liter
How to make repeat long numbers shortcut ?20 Aug 2005 18:21 GMT1
Anybody knows how to make repeat long numbers shortcut ? Instead of
input repeat long numbers, can I make a shortcut ?
Example :
A1 = 4895028
need information20 Aug 2005 18:19 GMT5
Want to know if you can have more than one number in a formula for a column
index number.
using item#s to link cells20 Aug 2005 16:54 GMT3
I am trying to create a worksheet that requires an specific item# to be
entered into a cell, which has values attached/linked to this.
for example:
if a user enters a drivers license number in one cell (blank, no
Counting Unique Values Given Criteria20 Aug 2005 16:22 GMT2
My data table is setup like so:
93000    A    Tech1
93000    B    Tech1
93000    C    Tech2
binary bit word20 Aug 2005 14:55 GMT2
Can the 10 bit limit on a binary word be changed to a 15 bit word? I need to
convert a decimal to binary but my decimal number can be as high as 65535 and
because I'm limited to only 10 charactors I can't use this function.
Positive Results20 Aug 2005 14:45 GMT3
How can I use a formula to subtract a number in one cell from a number in
another cell then display the result only if it is positive or greater than 0?
Need if Statement20 Aug 2005 13:59 GMT2
Column G has header qtys12mo (quanity sold last 12 months)
Column H has header onhand (quanity on hand)
I need an if statement that compares the values in these two columns
and returns the value T or Blank
 
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.