| Thread | Last Post | Replies |
|
| formulas | 19 Sep 2006 22:03 GMT | 4 |
To you pros out there this may sound stupid. If taxes are 8.160% what formula would I use to get the exact amount. Not sure where to put the decimal point. Thanks
|
| How do I sort data? | 19 Sep 2006 20:47 GMT | 2 |
I have a range of data and needed to sort it by more than three types. When I go to "data" then "sort" it only gives me three different sort types. Is there any other way that I can sort 4 or more types.
|
| Working night and day..... Timesheet | 19 Sep 2006 20:36 GMT | 5 |
In Out In Out The total time I get Overtime 15:00 18:30 19:20 02:00 -13,83 0,00 I'm using this Formula:
|
| How do i add a column of values based on another column in excel | 19 Sep 2006 20:29 GMT | 2 |
I am doing up a minor budget scheme and I am a little stuck on this one. I have 2 columns. First column is an amount and the second column has different they type of amount of the first column. eg:
|
| Sumif referring to range names formulas not updating | 19 Sep 2006 20:14 GMT | 1 |
I have several sheets rolling into a summary sheet. The data is by location and data type. Using SUMIF referring to range names to get the numbers in the right place. My formulas are not updating automatically though automatic calculation is selected in Options.
|
| Excel formula | 19 Sep 2006 20:03 GMT | 1 |
I am looking for the formula to enter in Excel to populate a cell with the text description that corresponds to the selected numeric value selected in a separate cell. Thanks.
|
| Macro within a function? | 19 Sep 2006 19:57 GMT | 1 |
Is it possible to put a macro inside a formula? For example, can I make the true value fo an IF function run a macro? If so, how? I can't find it in the HELP!
|
| HOW CAN I SERIALIZE SHEETS IN EXCEL | 19 Sep 2006 19:31 GMT | 1 |
I am trying to serialize a purchase order form in excel automatically so the number each time I print it will advance by increments of 1
|
| Excel 2003 SP2 | 19 Sep 2006 18:48 GMT | 3 |
when formatting cells with negative numbers in currency, drop down box does not include brackets as option. line 3 option is same as line 1 -$1,234.00 any suggestions besides re-install
|
| Worksheet Link | 19 Sep 2006 18:09 GMT | 1 |
I built the following formula as instructed in the Help. =DSUM(BUD2006.XLS!ACTUAL,23,$A$9:$B12) When I close the BUD2006 file, the formula changes to the following: =DSUM('D:\work\BUD2006.XLS'!ACTUAL,23,$A$9:$B12)
|
| Calculating values from multiplesheets with multiple criteria | 19 Sep 2006 17:38 GMT | 19 |
I'm sure this is simple nut I have no idea! (Apologies for incorrect terminoligies) *Background* My workbook two worksheets of data.
|
| MATCH? | 19 Sep 2006 17:29 GMT | 1 |
I have 10 columns/1 row that have different numbers. I want the 11th column to match for a specific number if found. Here's an example with expected result 1 2 3 4 X
|
| code help please | 19 Sep 2006 16:40 GMT | 2 |
i am trying to create a simple macro whereby i add in a new person to a holiday chart which involves adding in some formula lines and so on, but how do i make sure my macros start copy pasting at the next available line ?
|
| Conditional formula | 19 Sep 2006 15:55 GMT | 4 |
I have a series of data in a two row and need to make a conditional lookup. The problem is, that a conditional formula is restricted to 7 arguments. The problem: I have two rows. In the upper row is a target value for each month and in
|
| date/time calculation needed | 19 Sep 2006 15:54 GMT | 2 |
I'm looking for a simple formula to add 140 hours from a entered data/time. Example: In D6 a date/time is entered. In E6 140 hours is added giving the results in a new date/time format. This is probably simple but having problems making it work. Also, how would
|