Howdy~ I am using excel to complete weekly employee reviews. The employee rating is done on a point scale. E.g., outstanding= 10, good = 8....etc In the...

=INDEX(LINEST(F17:N17,F16:N16^{1;2;3}),1) The above formula is part of a much longer formula. I want to repace the references with the INDIRECT function but...

1) basically would like to get the following statement to work: =if(foo!H2=ssbs,"ssbs2","foo'!H2") basically if fooH2 contains the value SSBS i need to return...

Hello, I need a function that looks at two conditions and returns a value. For example, I need a to look at cell H3 wich is CAPONE and also look at cell a13...

I an building a worksheet for baseball registration. I need to compare the Birthdate to the date we use to determine playing age in a division. I...

I have a formula as follows: C1=A1*B1 (assume A1=$482,933 and B1=0.9695) My expected result is $468,203. However the actual result shown in C1 is $468,181. It...

sure this is easy for you smart ones....... Column A has identifiers for locations 1-11 Column B has test scores I want average test scores for each of the...

This is driving me crazy....I am trying to debug and understand some cell computations using Excel 2003...but all it does it return an #VALUE...

Assuming I have two columns (category and value), what formula would list all values in a given category?

I'm trying to use a multiple "multiple" IF/WHEN formula for when a number falls between two numbers. For example, if a number falls anywhere between 1000 and...

Hi, I'm new. Okay, so I'm being a little lazy in that I could sit here and search threads until i'm blue in the face -- but blue's not a good color for me. ...

Hello...Hopefully somebody can help, because I no longer remember how to do this. I am trying to populate a random number list. I need 137 different random...

Hi, I'm using this formula - =COUNTIF(Registers!E57:GB57,"ü")/COUNTA(Registers!E57:GB57)*100 Is there a way of developing it so that if there is no data to...

Hi, Hope you all had a good christmas and new year. I'm trying to produce a holiday tracker and need to distinguish between days booked off and days had off....

Pivot tables in Excel 2003 are all fine, except - I typed a date incorrectly in the database and now the Pivot table retains this mistake when you click the...

I have a spreadsheet where all orders are entered as the come in. Each order has a unique date, rep, dollar amount, quantity and so on entered in rows. I want...

Need some help. This is the formula I have now. It figures a salary range and a categorilcally eligible logic test. If a household with x number of people...

Hi, What I'm trying to do is get a count of cells from one column based on cells that do not contain specific text in another column, i.e.; A B 1 at...

Range D15 through D830 contains numbers of various numeric values. In column F15 I want to report the total number of entries in D15 through D830 that fall...

I have a sheet where i export in data that has to have text to columns ran on it in order to get it out of a single cell. From there I need to find the column...