Functions

Function Error IF Statement
The follow work fine in seperate cells. =IF(AND(R7>0,O7="M"),(R7*I19+50)*0.093,(0)) =IF(AND(R7>0,O7="Q"),(R7*I19+50)*0.27,(0)) =IF(AND(R7>0,O7="S"),(R7*I19+50)*0.53,(0)) =IF(AND(R7>0,O7="A"),(R7*I19+50),(0)) What I want to do is combine the 4 above in 1 cell so the results show in a single cell. I can't g... 12 May 2010 09:09

Copy If rows to another worksheet
I need an Excel 2003 formula that looks at a column and copies each row that contains a variable ("A") to another spreadsheet. ... 11 May 2010 21:15

YTD with conditions
Hello, I produced a formula that I need to have expanded. =SUM('2010 Actuals'!E2:INDEX('2010 Actuals'!E2:Q2,MATCH(Sheet1!C5,'2010 Actuals'!E1:Q1,0))) I would like to do another condition based on my Category (E). It needs to sum all values in the given Category. As you can see, I have one condition for P... 12 May 2010 10:16

Average range of discontinuous cells
I have a block of columns (P-CT) that I need to average but only every 4th one. Example: I need to average P, T, X, AB, AF, AJ, AN, AR, AV, AZ, BD, BH, BL, BP, BT, BX, CB, CF, CJ, CN, CR. If I just type =AVERAGE(selecting these cells) it gives me 40238 when the only one with a value is cell P. These cell... 11 May 2010 14:33

VLOOKUP use column name not number
Is there a way to use VLOOKUP to search for a column name and return the value in that column, rather search for a column number. -- Thank you, Kathy ... 11 May 2010 21:15

Forecasting
I'm attempting to forecast the amount of money spent on the purchase of company cars for the remaining of the fiscal year. (Column 1: Costs of cars and Column 2: Volume of cars) I've done a simple regression but the Adjusted Square value was 80%. I dont think this would be the best way to forecast. I created an... 11 May 2010 13:25

How can I set a "page end" point on a large worksheet?
I am a fairly new user to Excel. I have created a worksheet with over 200 lines of data. When I use the "control end" shortcut, I end up way down at the end, if you know what I mean. Is there a way to set the end of my page at the actual end of my data? Thanks. ... 14 May 2010 16:09

Auto fill Cells with text
I am creating a Game scoresheet and would like to know if I can use a drop down menu in one cell and automatically fill the below cells with players of the drop down selected team. example cell 1 TEAM1 TEAM2 <--these are drop down menus cell 2 PLayer1 ... 11 May 2010 13:25

Countif help needed
I am trying to use a countif statement for column A to count the number of times a District is "CAR" PLUS those CAR listings where column N (DAYS) is 499. I've tried =COUNTIF(A:A="CAR")+(N:N=">499") and =SUM((District="CAR")*(Days>499)) as an array, but neither works...help please!! Jess ... 11 May 2010 14:33

vlookup across multiple pages
I'm trying to use vlookup to give me a summary of some number throughout a workbook. It has to sum across about 25 worksheets. not all worksheets have the date I'm looking up so I will need to set the range_lookup to true so that it will add the last inventory count before my specified date. I can use the fo... 11 May 2010 16:48