| Thread | Last Post | Replies |
|
| I PUT A FORMULA IN A CELL BUT I DON'T GET NUMBERS BUT THE FORMULA | 24 Sep 2005 13:46 GMT | 3 |
when I put a numbers in the cell and click inter..I see the formula in the appointed cell but not the number it self ..please help
|
| Excel | 24 Sep 2005 11:14 GMT | 1 |
I am trying to make up new employee time sheets. What I am wanting to do is when I enter all the hours on each individual sheet for a project the actual hour will convert over to the project hours sheet at the same time. How do I do this.
|
| nested formula with if condotion | 24 Sep 2005 11:02 GMT | 2 |
can anybody helpme out to put formula using if or any other function, to get a desired value using a random formula. My problem is: I will have integer values in thhe cells A1,A2,A3,......An.
|
| I want to customize a text depending of anwers in a lookup table | 24 Sep 2005 10:04 GMT | 1 |
I have a lookup table (survey) and I want the total output in a text format (a paragraph)
|
| nested formula | 24 Sep 2005 10:03 GMT | 3 |
Hi every body, I'm a new member in this group. I have a Question regarding nesting of formulae in one cell. Cell A1 can have any integer value between 1 to 100.
|
| Mixing up the arguments | 24 Sep 2005 09:54 GMT | 2 |
I would like to be able to have an IRR function that has formulas and numbers inside. For example: =IRR((-a1,c3,400,d4+f9,e10),0.12) Of course, Excel doesn't permit this. I tried the value function (i.e.
|
| Worksheet and Word | 24 Sep 2005 09:47 GMT | 1 |
Is it possible to have two documents, one an EXCEL WORKSHEET, the other a WORD document open AT THE SAME TIME AND BOTH VIEWABLE WITHIN THE SAME WINDOW... this way, i can see some items in word and manually insert the items into
|
| Text Functions, | 24 Sep 2005 09:14 GMT | 8 |
Hello, Can someone help me solve this problem. I have a mailing list consisting of single cell names (first <could be initials>, Middle, Last, and a sufix <Sr. Jr. IV, etc.>). What I have been trying to do is to separate the names into two columns,
|
| Validation - Weekend Or text | 24 Sep 2005 09:02 GMT | 3 |
I'm trying to validate cell D1 so only weekend dates are approved *or the text Paid. I have tried this in the custom formula box: =OR(WEEKDAY(D1,2)>5,D1="Paid") This accepts weekend dates but for some reason won't accept the tex
|
| Need Help | 24 Sep 2005 08:51 GMT | 1 |
Coul you tell me any method beside macro if I want the cell A2 to return any number or text if cell A1 is filled with colour. Thx for any help Ray
|
| How do I display contents of an adjoining cell? | 24 Sep 2005 05:08 GMT | 3 |
I need to search alphanumeric contents of column A with the contents of column c. If a match is found, I want to display the contents of the adjoining cell in column b. Ex:
|
| if then statement | 24 Sep 2005 03:02 GMT | 6 |
if a:a contains "*Total Tele*", then add C:C if C:C is <24
|
| INDEXing Question | 24 Sep 2005 02:31 GMT | 3 |
I have my data in a table like this: Data Table BOX017 BOX060 BOX161 A 109 B 38275 4
|
| Every 28 days | 24 Sep 2005 02:27 GMT | 4 |
Hello from Steved Is this possible please. Feb the 4th then every calendar days colour the cell red so in this instance March the 4th being the 28th day the cell will change to a red background.
|
| =today() | 24 Sep 2005 00:03 GMT | 8 |
Ok I have another question. With the =today() function is there a way to automaticaly make the date a value so It will not change again, say once you mail the file, or when you post it to web folder or something?
|