| Thread | Last Post | Replies |
|
| IF Formula Determination | 22 Jan 2004 21:03 GMT | 4 |
I have 4 columns / cells: A1 = current price B2 = low price C3 = high price
|
| trying with out quotes... If-Then problem | 22 Jan 2004 21:01 GMT | 1 |
Sorry, this is a repost from about ten minutes ago. I made the mistake of using quotes. Lets try again. I sell items on ebay. I have learned how to create a few
|
| Excel Reverse Address type of problem | 22 Jan 2004 20:57 GMT | 1 |
I'm trying to figure out a way that I can search portion of a worksheet for a value and have the result be the address of that cell. It seems that Excel will only search an address and display it's value. ANYONE???:confused:
|
| Two Instances of Workbook | 22 Jan 2004 20:49 GMT | 2 |
I am running Excel 2000 on XP Pro. When I open a workbook, it opens two instances of this workbook. Can someone please tell me how to not do this? This only happens with one workbook. Others are OK. So I
|
| Vlookup returns #N/A# | 22 Jan 2004 20:40 GMT | 3 |
I exported a table from Access to Excel. When I do a vlookup on the table, I get the #NA#. If I retype the index column's cell entry in the lookup table, the result of the formula changes to the correct result. I have
|
| Worksheet name equal cell value | 22 Jan 2004 20:20 GMT | 3 |
I am looking for a way to have worksheets automatically renamed to the value entered in cell A1, either individually or all together (for all worksheets in the workbook). Need this in a hurry if anyone has a
|
| Zip + Four Question | 22 Jan 2004 19:47 GMT | 1 |
I have a spreadsheet being used to merge addresses into letters and labels. The column containing the zip codes are all either five-digit or five-digit+four with no dashes to separate the five and four digits. Can someone please tell me how to insert this command into the ...
|
| Remove link! | 22 Jan 2004 19:41 GMT | 2 |
Is there a way to remove links (VBA or otherwise)? I know that my spreadsheet is no longer linked to another worksheet but when you click link, the "Source File" still bears the name of the previous source. How can I delete
|
| more 1-2-3 converting | 22 Jan 2004 19:25 GMT | 1 |
I tried to make this one into Excel @IF(@ISEMPTY(AT24)#AND#@ISEMPTY(AX24);"";@IF(@ISEMPTY (AT24);@DAYS(AX24;@TODAY);@DAYS(AX24;AT24))) whereas 2003-10-14 is the content of AV column..
|
| Round Function | 22 Jan 2004 19:08 GMT | 2 |
How can I change .93 to .95 or 2.97 or 3.00. I have a list of 1000 entries like this.. Can somebody Help.
|
| i want to generate hands of poker... | 22 Jan 2004 18:28 GMT | 10 |
I want to generate dealt cards like in poker... I created a list 52 numbers long...next to which i put 1s 2s 3s etc.... I have in my mind how this could work just using "if"
|
| APR annual percentage rate formula/function | 22 Jan 2004 18:21 GMT | 2 |
Is there a function, or perhaps you know a formula that will calc an APR for my home loan which includes fees. I dont want a canned internet calculator, i'd like the formula and/or function.
|
| Look up values | 22 Jan 2004 18:11 GMT | 3 |
I am trying to write a formula to look up values in column B depending on two values in column A. E.g. Col A
|
| special function | 22 Jan 2004 17:38 GMT | 1 |
I am looking for a function similar to "if(condition; calculate something; retain current value)". This means, the value in the cell shall only be recalculated, if the condition is met, else the current value is kept.
|
| Excel Lists | 22 Jan 2004 17:30 GMT | 9 |
Want to create a drop-down list from a data range in another Excel workbook. When I try this the Validation menu gives me an error that says it cannot use data from another workbook or even another worksheet. How can I
|