| Thread | Last Post | Replies |
|
| web page numbers | 21 Aug 2005 06:52 GMT | 3 |
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 EXTIMATOR | 21 Aug 2005 06:08 GMT | 1 |
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 Error | 21 Aug 2005 03:22 GMT | 2 |
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 arguments | 21 Aug 2005 02:22 GMT | 9 |
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 tabel | 21 Aug 2005 00:05 GMT | 1 |
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 cell | 20 Aug 2005 22:25 GMT | 3 |
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, HELP | 20 Aug 2005 21:34 GMT | 5 |
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 choose | 20 Aug 2005 19:15 GMT | 3 |
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 GMT | 1 |
Anybody knows how to make repeat long numbers shortcut ? Instead of input repeat long numbers, can I make a shortcut ? Example : A1 = 4895028
|
| need information | 20 Aug 2005 18:19 GMT | 5 |
Want to know if you can have more than one number in a formula for a column index number.
|
| using item#s to link cells | 20 Aug 2005 16:54 GMT | 3 |
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 Criteria | 20 Aug 2005 16:22 GMT | 2 |
My data table is setup like so: 93000 A Tech1 93000 B Tech1 93000 C Tech2
|
| binary bit word | 20 Aug 2005 14:55 GMT | 2 |
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 Results | 20 Aug 2005 14:45 GMT | 3 |
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 Statement | 20 Aug 2005 13:59 GMT | 2 |
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
|