Functions

IF AND question
Hi there, I need a function that can provide one of three answers: 1 2 1 1... 3 3 4 4... ? ? ? ?... If A1 = 1 and A2=3, answer 106; but if A1=1 and A2 = 4, answer 104; but if A1=2, regardless of A2, answer 95. The next function for column B is the same, except the answer is dependent on the value del... 6 May 2010 07:27

Why does this confuse me?? -- ? on Offset function
I'm trying to understand how/why this works... =OFFSET(A12,MATCH(MAX(E12:E300),E12:E300,0)-1,) So the reference cell is a12 - got that Understand the MATCH/MAX functions. I'm confused about the -1 aspect of the OFFSET function. If I understand this it's referencing one row below the reference A12... however ... 5 May 2010 20:31

Present Value of equal payments of a future value
I have a known future value = $300,000 worth of stock options in year 2012. A third of this value $100,000 will vest on 12/31/2010. A third of this value $100,000 will vest on 12/31/2011. A third of this value $100,000 will vest on 12/31/2012. Estimated rate of increase per year 5%. How do I find the prese... 5 May 2010 20:31

expand row to fit
Is it possible to format a cell / row so that if the text in a cell is longer than the width the text wraps and the row height expands to include the extra line(s)? Thanks, Peter. ... 5 May 2010 20:31

Using external query (mdb) for dynamic date range
I'm trying to set up an Excel workbook with a dynamic link to an Access database containing quality data, involving dates. I want the workbook to always import data for the last 90 days. When I try to set this up using MS Query, to try to filter data I've tried several different variations where time is great... 5 May 2010 20:31

How to clear all checkboxes on a form?
That's it. How is it possible to create push-button functionality that resets all checkboxes to empty? Also, is it possible that pushing a button could increase a counter, or light up a first, second and third cell, that would then be reset by the button I asked for above? I thank you for your time. Arl... 6 May 2010 11:57

Referencing a cell in other worksheet that is using autofit ro
Thanks Bob. Do I type that in both worksheets or just the one receiving the information? I pasted it in just as you wrote it, but I don't see anything different. I will try again. Thanks -- Bermi Girl "Bob Umlas, Excel MVP" wrote: Right-click the sheet tab, select View Code, enter this: Privat... 5 May 2010 21:37

Calculate next workday after adding calendar days to date in c
Hmmm, That could finish on a weekend date. There must be a simpler way but until then try this monstrosity =A1+100+CHOOSE(WEEKDAY(A1+100,2),0,0,0,0,0,2,1)+SUMPRODUCT((Holidays>=A1)*(Holidays<=A1+(100+SUMPRODUCT((Holidays>=A1)*(Holidays<=A1+100)))))+CHOOSE(WEEKDAY(A1+100+CHOOSE(WEEKDAY(A1+100,2),0,0,0,0,0,2,1)+SU... 6 May 2010 19:52

Percentages breakouts for Ranking
I have this request where it is taking several locations and eight different metrics but weighting them differently depending on their category to get an overall ranking. Here is an example: Metrics: Column B - M1 (28%) C -M2 (12%) M3: Depending all the call category could be D -(30%), E - (15%), or F - (7.5%)... 5 May 2010 17:10

Pivot Table Columns
I have a two rows of labels but the second row of labels I want them in one column not across as a column heading as I am using the column headings for another purpose. We have two names for our salons the first is a source code from an older system and the second is the real name I want to list both together ... 6 May 2010 04:12