using find and replace it's making me look in another file to upd 0 482 (6/6/2010 5:22:33 PM)
I have used the find and replace function several times in the spreadsheet to update the fromulas monthly. For some reason when I use it this month it wants me to look in another file to "update values"? T...
Utf

Trying to get this if statment to work 2 392 (6/5/2010 6:29:43 PM)
I have excel 2000. I am trying to get this formula to work. It does not give me any errors or anything It just will not return the number in the cell that it references Cell CJ44 has the formula Here is...
Cerealkiller

Checkbook calculations 2 645 (6/6/2010 4:06:19 PM)
I am trying to create an Excel worksheet to calculate my checkbook. I want to be able to enter different transactions and have them added or subtracted from my balance, as well as keep a running balance. An...
Utf

Complex AND OR Formula 9 459 (6/5/2010 9:07:18 PM)
HI I need to express something in a formula , and am having trouble with it. I need to say this : IF E2 CONTAINS "1bx" OR "2bx" OR "3bx" OR "4BX" AND J2 =11 THEN PUT 1 , OTHERWISE PUT J2 Can s...
Colin

maintaining constant percentage 1 419 (6/5/2010 4:43:08 AM)
Am trying to construct formula in excel 2007 for maintaining a constant percentage. Example: company 1 has 1,000 shares. Company 2 wants to purchase 10% of company 1 and always maintain the 10% rate. Buying 1...
SF123 (1)

Select a worksheet 2 472 (6/5/2010 10:22:00 PM)
I'm using the below formula to determine the specific type of equipment from a list named: database =IF(VLOOKUP($J$2,Database!$A:$U,21,FALSE)=$X$2,"Desktop",IF(VLOOKUP($J$2,Database!$A:$U,21,FALSE)=$X$5,"N...
Utf