| Thread | Last Post | Replies |
|
| Add "+" plus symbol to positive percentage | 21 Aug 2008 18:52 GMT | 4 |
Hi, Im calculating a precentage of two figures: A1= 100 A2=200 =(A1/A2)-1 This gives me a negative result "-50%"
|
| import question | 21 Aug 2008 18:35 GMT | 1 |
Hello, I am trying to import one excel.csv into another excel 2007. the problem is the worksheets have different field names. Anyone have any thoughts on how to get the data from .csv to be entered into .xls. Thank you
|
| SUMPRODUCT / SUMIF on Multiple Worksheets with Multiple Criteria | 21 Aug 2008 18:22 GMT | 2 |
I have multiple sheets (Sheet A, Sheet B, Sheet C) with label, time, and data i.e A1 blank B1:E1 labels (ie. TC1, TC2, TC3, TC4)
|
| cursor | 21 Aug 2008 18:07 GMT | 2 |
suddenly when I opned my spreadsheet and use the arrow to move the cursor the box isn't moving the columns are moving.. Help!
|
| How can i print one long column side by side? | 21 Aug 2008 17:50 GMT | 2 |
I have one long column of data and its going to print on many pages. However I want to print it on one page, side by side. How do I do this?
|
| Based on the selction from a drop down box, jump to a cell | 21 Aug 2008 17:14 GMT | 1 |
I would like the cursur to jump to a column in the current row depending on what was selected from the drop down box. This is for data entries.
|
| Help with dates!! Excel 2003 | 21 Aug 2008 16:54 GMT | 3 |
I have two spreadsheets and i am trying to do a HLOOKUP however i get a #N/A The problem: They both have the date 10/1/07 but if i change the one date to 9/30/03 it will do the look and when i change the dates to general, the numbers match with the different dates but not if they ...
|
| Round a number help | 21 Aug 2008 16:53 GMT | 4 |
Hi I want to round up a number only if the decimal part is greater than 0.25, if not leave it as a whole number Thank you.
|
| Showing Last Value in a column | 21 Aug 2008 16:52 GMT | 3 |
Hi - is there any way that if I have a column with numbers in each cell, to be able to put in a formula (without using a vlookup) that will give me the last value in that column please? (e.g the column numbers range from 1 to 20 and I want a cell to bring
|
| if condition formulas | 21 Aug 2008 16:12 GMT | 1 |
Dear support Can you give mre the details of if condition formulas like the cell values between 0 to 5 will have a incetive if 5/- , values between 6 to 10 will have incentive of 10/- amnd so on. Please describe with syntax and example.
|
| Banner ad Manager | 21 Aug 2008 16:08 GMT | 1 |
I am unable to use the Banner ad Manager with Sharepoint services or Frontpage server extensions. Is there an alternative method of displaying rotating advertising images in Frontpage?
|
| Networkdays | 21 Aug 2008 16:04 GMT | 6 |
This function works great if I don't try to exclude the holiday....Here's my problem, I have columns for the entire month and I need to calculate the number of weekdays AND the number of weekdays less the holidays....this works fine if my holidays are in a row i.e. 12/24 and ...
|
| Excel 2003, European number format | 21 Aug 2008 16:03 GMT | 2 |
Hi, i'm in the UK but need to show some numbers in Excel 2003 using the European format i.e. instead of 10.90 i have to show it as 10,90 Can anyone tell me how to do this? Thanks very much
|
| IF > then return... | 21 Aug 2008 15:45 GMT | 3 |
Need some help writing a formula Column A Column B Column C Column D Result Return 500 652 450 710
|
| Help with Variable Ranges! | 21 Aug 2008 15:30 GMT | 1 |
I desperately need some help with varying a range in a function. I'm trying to make some of my reports more automated, and I would like to be able to fill out one reference cell with the current month and have the formulas now include any new data into their calculations. I ...
|