Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / April 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How to to put together this function below21 Apr 2007 19:40 GMT2
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 Value21 Apr 2007 19:18 GMT3
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 Month21 Apr 2007 14:44 GMT7
Is there a way to find the second Wednesday of each month using Excel
97?
YTD calculation using same cell21 Apr 2007 14:14 GMT3
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 Validation21 Apr 2007 14:10 GMT2
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 bar21 Apr 2007 13:54 GMT4
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 macro21 Apr 2007 13:40 GMT3
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"
VLOOKUP21 Apr 2007 10:36 GMT1
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 200721 Apr 2007 07:16 GMT3
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 hours21 Apr 2007 06:32 GMT1
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 GMT4
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 dates21 Apr 2007 02:17 GMT3
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 Formulas21 Apr 2007 02:15 GMT2
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 result21 Apr 2007 01:42 GMT2
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 Help21 Apr 2007 01:24 GMT8
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 ...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.