| Thread | Last Post | Replies |
|
| How to to put together this function below | 21 Apr 2007 19:40 GMT | 2 |
How put together this formula to determine if my blood pressure is in normal range: If =<120 return "Normal" If between 121 and 139 return "Pre-hypertension"
|
| Max Cell Value | 21 Apr 2007 19:18 GMT | 3 |
Looking for a function or macro that captures and retains the maximum value of a fluctuating real number in a cell
 Signature Saskatoon Jerry
|
| Finding Particular Day of Month | 21 Apr 2007 14:44 GMT | 7 |
Is there a way to find the second Wednesday of each month using Excel 97?
|
| YTD calculation using same cell | 21 Apr 2007 14:14 GMT | 3 |
I am creating a pipeline that has new data entered each week. I want the weekly figure to automatically add on to the monthly figure. Eg. A B C
|
| Excel Data Validation | 21 Apr 2007 14:10 GMT | 2 |
I've got a spreadsheet on which I'm using Data Validation for a number of fields. A few questions: 1. Where is the best place on the worksheet to put the data validation lists so that they won't get deleted?
|
| Function bar | 21 Apr 2007 13:54 GMT | 4 |
In older versions of Excel the symbol on the left side of the function bar used to be an "=". Whenever you type a formula in the formula box, a grey box appears below it showing what the sum would be based on the formula you just typed in it. In the 2003 version the "=" symbol ...
|
| If, then: to run macro | 21 Apr 2007 13:40 GMT | 3 |
Is it possible to have a macro run when a certain condition is met on a worksheet (or between worksheets). Example: If CellA1 on sheet1 <> CellA1 on sheet4 then run the macro "Evaluate"
|
| VLOOKUP | 21 Apr 2007 10:36 GMT | 1 |
if the table column that is being used for column index contains formuales the vlookup results in an error message unless that column is paste special with values. Is there any way to overcome this ? Thanks
|
| formula in excell 2007 | 21 Apr 2007 07:16 GMT | 3 |
Ok, I am trying to create a formula that will do the following: If cell F2 has any number between 23 and 28, I want it to multiply cell E2 by 20%, if it has 28.01 and 32, then I want it to multiply cell E2 by 25%. If it has
|
| regular and overtime hours | 21 Apr 2007 06:32 GMT | 1 |
Need help on solving a problem, I have A1 to G1 as (Sun thru Sat) for Days off with pay, A2 to G2 where I put hours; then A3 to G3 is for regular hours; then A4 to G4 is overtime hours, I have the regular hours ( A3 to G3 ) set up perfect to work with overtime hours ( A4 to G4), ...
|
| How to auto-return to next cell that accepts data. | 21 Apr 2007 03:44 GMT | 4 |
Hello, let me begin by saying that I'm completely new to excel and a complete ignoramus when it comes to this stuff so I apologize in advance for any stupid questions. I just opened excel for the first time 2 days ago, so here we go.
|
| How to Calculate No. of Days between two dates | 21 Apr 2007 02:17 GMT | 3 |
In Column A, I have a list of dates. (MM/DD/YYYY) In Column B, I have another list of dates. (MM/DD/YYYY) What's the formula, in Column C, to determine the difference in the number of days between Columns A and B?
|
| Copying Formulas | 21 Apr 2007 02:15 GMT | 2 |
I have an array formula that compares a master list with an updated list, and shows any new items: =IF(OR(EXACT('New Task Page'!C2,'5.2- Task Report'!C2:C6500)),"",'New Task Page'!C2) . I want to drag the formula down the column so that the next cell reads: =IF(OR(EXACT('New Task ...
|
| EXACT doesn't fill in the result | 21 Apr 2007 01:42 GMT | 2 |
I know this is probably the simplist thing, but I cannot figure it out. I put in the EXACT function via the tool, enter my values for cell1 and cell2. In the function box it shows TRUE or FALSE, but in the cells themselves only the formula shows (=EXACT(A4,C4) - not TRUE or ...
|
| Poor Dumb Teacher Needs a Little Help | 21 Apr 2007 01:24 GMT | 8 |
I need to generate a list of numbers that fall within a certain range based on a "base" percentage. I am generating a sample gradebook. Student "A" has a semester grade of 83%. I need to generate a list of 24 "assignments" that would average out to that 83% semester grade -- the ...
|