| Thread | Last Post | Replies |
|
| multiple conditions with IF function. | 25 Jun 2007 18:05 GMT | 2 |
I want to set a condition with multiple options, how do i do it?
|
| linked info | 25 Jun 2007 18:01 GMT | 1 |
I have a workbook with a summary page linked to several source documents. The value on the summary page cells is not the same as the value on the source document cells. "Links" under "Edit" is not highlighted so I can not use this function.
|
| Need to know what formula to use | 25 Jun 2007 18:00 GMT | 7 |
I'm creating a spreadsheet in which I want to enter data and have the date entered be used to separate the information so I can total it. For instance, all entries made in January are totaled, and February, etc. So that I can produce a monthly report and then a yearly total. I ...
|
| Excel 2007 backwards compatibility - nesting functions | 25 Jun 2007 17:58 GMT | 6 |
Well, I never thought I'd run into this one! But, a problem came up at the office with designing a worksheet where difference between two time values is calculated. The problem was that a user may enter something that isn't recognized by Excel as a time - for example,
|
| IF function not working in conditional formatting | 25 Jun 2007 17:18 GMT | 7 |
I'm trying to apply conditional formatting to a spreadsheet using the IF function. I know I'm using the correct formula. But the formatting is not being applied. It's like the function is not working.
|
| Formula Help Please | 25 Jun 2007 16:44 GMT | 5 |
Here is a clip from the data I need to select from. 11-Jun IP D 12-Jun IP D 12-Jun IP D
|
| Copy formulas not working | 25 Jun 2007 16:39 GMT | 1 |
I am trying to copy simple formulas in a spreadsheet and Excel appears to only be copying the values. But when I go to the cell, it has the correct formula, but the wrong result. I have not seen this before...can anyone help?? The formula I copy has the same result in ever ...
|
| auto selection | 25 Jun 2007 14:41 GMT | 1 |
If I have a worksheet with the following info 1 2 3 4 200 80 180 500 and I give the the following info
|
| Why do I get #NUM! for a GEOMEAN calc on a set of positive vals | 25 Jun 2007 13:42 GMT | 14 |
I have a set of around 400 values in a sheet which range between 1 and 200,000. When I try to calculate the GEOMEAN value I get a #NUM! result. If I calculate the accumulating GEOMEAN (A1:A1, A1:A2, A1:A3 etc.) I find that the #NUM! starts when I hit the 174th item, which looks ...
|
| If logical value problems | 25 Jun 2007 13:24 GMT | 3 |
I am trying to run the formula containing the =SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)) function from this Microsoft Office Help link: http://office.microsoft.com/en-us/excel/HA012260381033.aspx?pid=CL100570551033
|
| Pasting across worksheets | 25 Jun 2007 12:29 GMT | 2 |
How can I put the same text into the same cell in all worksheets in an Excel file? I want to take the text in C3 in worksheet 1 and put in in C3 in all worksheets in the same file.
|
| IF / SUMPRODUCT HELP | 25 Jun 2007 11:55 GMT | 5 |
I am using an IF statement to check a specific criteria but on some responses I get a "FALSE" if none of the criteria is meant or 0 if part of the criteria is meant. I would like to tigten this up and have a 1 or 0 response.
|
| Help with Dates in a Formula | 25 Jun 2007 11:21 GMT | 6 |
I need to change the reference (=B474) in this formula to something that will select all entries in the range A12:A399 that fall within the month of SEP 06 then sum the numbers found in Column E. The cells in range A12:A39 are formatted as dates. I don't know how to enter this ...
|
| How do I include part of a cell in text (string?) in another cell? | 25 Jun 2007 10:08 GMT | 2 |
I have a spreadsheet in which A:1 contains First and Second Names as a single entry, e.g. 'Fred Smith'. I want to be able to include only the First Name in statements in other fields, e.g. 'Fred can .' I have considered splitting the name across two
|
| Excel date format, NOT JUST DISPLAY !! | 25 Jun 2007 09:43 GMT | 3 |
i need the current date and time, in this format mm/dd/yyyy:hh:mm:ss i used the custom format, to get the desired result. But, wen i get into the edit mode (F2), it displays "6/25/2007 3:05:08 AM" Please help me with this, i need to COPY the date in mm/dd/yyyy:hh:mm:ss
|