| Thread | Last Post | Replies |
|
| Função Logaritimica | 10 Sep 2007 19:51 GMT | 2 |
Gostaria de saber como o excel calcula os valores que ele apresenta em uma função logaritimica. Por exemplo na equação y = -2.5279Ln(x) + 11.299. Como posso calcular os valores -2.5279 e 11.299 baseado nos valores de X (0.3, 1.0, 3.0, 10.7, 32) e Y (15.26, 12.26, 5.57, 4.74 , 4 ...
|
| Can not access small cross to pull-down data | 10 Sep 2007 18:04 GMT | 2 |
I can no longer use the small cross in the corner of a cell to pull down formulas or dates. I must have somehow changed this feature. Please help. Thank you
|
| Count number of sheets | 10 Sep 2007 17:22 GMT | 5 |
Hi. I want to create a macro that will count the number of sheets in a particular workbook. Is this possible?
|
| "freeze" an imported realtime updated cell value | 10 Sep 2007 16:58 GMT | 6 |
how can I "freeze" a given value of a cell which is updated on a realtime basis, e.g., stock options prices imported from a sort of Bloomberg data diffusion service? I have a worksheet that evaluates options strategies for 10 options series calculating implied volatility on a ...
|
| COUNTIF | 10 Sep 2007 16:15 GMT | 6 |
if I want to count the number of rown where B4:B65535 > 31/07/06 and < 01/08/07 and C4:C65535 = "No" how would I express this please Thanks A
|
| IF Function Help | 10 Sep 2007 15:34 GMT | 5 |
I am creating an Excel spreadsheet to track permit holders. I need to assign user IDs to the first three letters of the last name of the permit holders. The column for the permit holder's name is column J. In column I, I need a formula to take the first three letters of the ...
|
| IF formula | 10 Sep 2007 15:17 GMT | 6 |
I've created a drop down list of companies and I want a formula that will display the relevant details (entered over a number of cells) when I select one of them. I've been using the below formula which I know is incorrect but might give you an idea of what im trying to do:
|
| IF Function | 10 Sep 2007 14:56 GMT | 3 |
I am trying to creat a worksheet to automatically calculate our football picks. So far, I have our teams listed in the first column, each in their own row (A3 - Indy, A4 - New Orleans). B3 would be the winner (Indy) Column C - is the person's pick (C3 = 0, C4 = 6)
|
| Excel formula question | 10 Sep 2007 13:14 GMT | 2 |
I am trying to figure out a new formula. I am trying to create a maintenance chart. There are services due on an engine at 12, 24 and 50 hours. I want to be able to input the time used on the engine and have all the service marks count down until they hit zero or a negative ...
|
| fill color not working in excel 2007 | 10 Sep 2007 12:56 GMT | 3 |
I just put office 2007 on my new laptop for work. I opened an old excel file created with excel 2003 and noticed my fill colors weren't in the cells I had put them in. I tried to add fill color. Nothing. I even tried to create a new worksheet and entered info in a cell, tried ...
|
| Simple IF statement | 10 Sep 2007 12:32 GMT | 4 |
I need to get a formula which says if there is any value in a2, then make a1 = "Accepted" Im sure I need an If statement, but not sure how I do the "any value" bit.
|
| Page Break Save | 10 Sep 2007 12:10 GMT | 1 |
Hi. Is it possible to save each page in the page break view in a new workbook?
|
| How do I update a checkbox as true when another has been updated | 10 Sep 2007 11:06 GMT | 1 |
I have a series of checkboxes but some are dependant on previous responses. I want to update a checkbox with a true response if one previous has been selected. Can anyone assist - in simpler terms if possible.
|
| Insert rows without effecting formulas | 10 Sep 2007 08:53 GMT | 1 |
Column A contains employee numbers, column B contains numbers that correspond to each employee. In column C are numbers that come from another source and should match up to those numbers in column B. In column D is the formula B-D. All
|
| Formula to Insert Rows | 10 Sep 2007 08:22 GMT | 3 |
I have scanned the posts and could not find the answer to my question. I want to be able to insert an entire row when a new client is added. For instance if cell A1 is Jane Smith
|