| Thread | Last Post | Replies |
|
| Trying to do a formula in Excel until the value is 0 | 27 Mar 2008 09:07 GMT | 5 |
I am trying to do the following formula in Excel: =IF(D224=0,E223+B224,E223-D224) I want to do this until the value of Column E = 0, if it does I want it to display "Current"
|
| Date formula | 27 Mar 2008 08:04 GMT | 3 |
I need a formula that will determine if dates ( formatted xx/xx/xx)in column B & C are = or greater than 1 year apart and if so to return value "Yes", if not return value "No". Thank you!
|
| I need help writing a complex equation. | 27 Mar 2008 05:19 GMT | 7 |
I have three columns that I want to draw data from combine it into a single line of data in another columns. So here’s the scenario. Column 1 has an employee # there’s two designations 01XXXX and 02XXXX. This is important. More on the importance of that later.
|
| Conditional Formatting | 27 Mar 2008 05:13 GMT | 2 |
Okay. I am needing to have a cells A, if the date entered is less than 90 days to be one color, and if it is greater than 90 days to be one color. Please help.
|
| OR Nesting? | 27 Mar 2008 04:52 GMT | 2 |
I'm trying to sum column B (minutes) that have different decriptions in column A. I want to sum only those descriptions that have the abbreviation of "PRJ" in them. Do I need to list out the entire descriptions somewhere else?
|
| Formula not updating | 27 Mar 2008 03:36 GMT | 3 |
I am using very basic formula to calculate sums on a spreadsheet, and usually it works fine, but for some reason they are no longer updating? Does anyone know why? The formula still seems to be in the cell, but it doesn't change when I amend the numbers above it.
|
| Information copying from sheet 1 to sheet 2 | 27 Mar 2008 03:02 GMT | 1 |
Stupid Question. I set up a file with 5 worksheets in it for daily data entry and print. But when i enter information in worksheet one it automatically get added to sheets 2, 3, 4 and 5. How do I stop it?
|
| #Ref! error using INDIRECT for file name | 27 Mar 2008 02:03 GMT | 3 |
I'm having trouble with the following formula =INDIRECT("'S:\14 Finance\SALES\07-08\[Week "&$B41&" 07-08.xls]Summary'!d118") where $b41 refers to a cell with a week number in it. When ever I open this file it returns a #Ref! error unless I open this particular file references
|
| Need a formula to average every other value in a column. | 27 Mar 2008 02:01 GMT | 3 |
I have columns with 100+ values. I need averages of the odd numbered rows and then averages of the even numbered rows. Any ideas?
|
| can't save in excel-pleeeeeeease HELP!! | 27 Mar 2008 01:56 GMT | 4 |
I can't save or save as in excel. Options are not highlighted. I used to be able to and I can on another computer using the same version. How do I change this?
|
| Hide Pivot Table Filters | 27 Mar 2008 01:15 GMT | 1 |
I've created a Pivot Table that uses filters in Excel 2007. Unfortunately, the filters show up above my actual PivotTable on the spreadsheet itself. Is there a way for me to prevent these from showing up while still filtering my data?
|
| what is the formula in excel for higher level of square roots | 27 Mar 2008 00:40 GMT | 4 |
the formula for squre roots in excel is SQRT(number) but what is the formula for higher level of roots?
|
| SHIFT G | 27 Mar 2008 00:19 GMT | 2 |
I have suddenly a problem on my hands. Whenever I press SHIFT + "G" the program search for data. This is very irritating as I write a lot of names (beginning with capital letters) in a excel sheet. How can I stop this "service" ??
|
| Insert files (pdf, word doc) in excel cell | 27 Mar 2008 00:03 GMT | 1 |
I would like to do a MS Word mail merge using excel as the data source for a fax blast. However, I need to send a specific page to a specific fax number. I was thinking of setting up an excel document with [name, fax number, document] columns as the data source, and then
|
| Exponential formula | 27 Mar 2008 00:00 GMT | 2 |
How do I raise a number to a value; e.g., cube, fourth . . . sevententh?
|