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 / June 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
multiple conditions with IF function.25 Jun 2007 18:05 GMT2
I want to set a condition with multiple options, how do i do it?
linked info25 Jun 2007 18:01 GMT1
I have a workbook with a summary page linked to several source documents. The
value on the summary page cells  is not the same as the value on the source
document cells. "Links" under "Edit" is not highlighted so I can not use this
function.  
Need to know what formula to use25 Jun 2007 18:00 GMT7
I'm creating a spreadsheet in which I want to enter data and have the date
entered be used to separate the information so I can total it.  For instance,
all entries made in January are totaled, and February, etc.  So that I can
produce a monthly report and then a yearly total.  I ...
Excel 2007 backwards compatibility - nesting functions25 Jun 2007 17:58 GMT6
Well, I never thought I'd run into this one!  But, a problem came up
at the office with designing a worksheet where difference between two
time values is calculated.  The problem was that a user may enter
something that isn't recognized by Excel as a time - for example,
IF function not working in conditional formatting25 Jun 2007 17:18 GMT7
I'm trying to apply conditional formatting to a spreadsheet using the IF
function.  I know I'm using the correct formula.  But the formatting is not
being applied.  It's like the function is not working.
Formula Help Please25 Jun 2007 16:44 GMT5
Here is a clip from the data I need to select from.
11-Jun    IP    D
12-Jun    IP    D
12-Jun    IP    D
Copy formulas not working25 Jun 2007 16:39 GMT1
I am trying to copy simple formulas in a spreadsheet and Excel appears to
only be copying the values.  But when I go to the cell, it has the correct
formula, but the wrong result.   I have not seen this before...can anyone
help??   The formula I copy has the same result in ever ...
auto selection25 Jun 2007 14:41 GMT1
If I have a worksheet with the following info      1       2       3        4
                                                                   200   80
  180     500
and I give the the following info
Why do I get #NUM! for a GEOMEAN calc on a set of positive vals25 Jun 2007 13:42 GMT14
I have a set of around 400 values in a sheet which range between 1 and
200,000. When I try to calculate the GEOMEAN value I get a #NUM! result. If I
calculate the accumulating GEOMEAN (A1:A1, A1:A2, A1:A3 etc.) I find that the
#NUM! starts when I hit the 174th item, which looks ...
If logical value problems25 Jun 2007 13:24 GMT3
I am trying to run the formula containing the
=SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)) function from this
Microsoft Office Help link:  
http://office.microsoft.com/en-us/excel/HA012260381033.aspx?pid=CL100570551033
Pasting across worksheets25 Jun 2007 12:29 GMT2
How can I put the same text into the same cell in all worksheets in an Excel
file?
I want to take the text in C3 in worksheet 1 and put in in C3 in all
worksheets in the same file.
IF / SUMPRODUCT HELP25 Jun 2007 11:55 GMT5
I am using an IF statement to check a specific criteria but on some
responses I get a "FALSE" if none of the criteria is meant or 0 if part of
the criteria is meant.  I would like to tigten this up and have a 1 or 0
response.
Help with Dates in a Formula25 Jun 2007 11:21 GMT6
I need to change the reference (=B474) in this formula to something that
will select all entries in the range A12:A399 that fall within the month of
SEP 06 then sum the numbers found in Column E.   The cells in range A12:A39
are formatted as dates.  I don't know how to enter this ...
How do I include part of a cell in text (string?) in another cell?25 Jun 2007 10:08 GMT2
I have a spreadsheet in which A:1 contains First and Second Names as a
single entry, e.g. 'Fred Smith'.
I want to be able to include only the First Name in statements in other
fields, e.g. 'Fred can .' I have considered splitting the name across two
Excel date format, NOT JUST DISPLAY !!25 Jun 2007 09:43 GMT3
i need the current date and time, in this format mm/dd/yyyy:hh:mm:ss
i used the custom format, to get the desired result.
But, wen i get into the edit mode (F2), it displays "6/25/2007  3:05:08 AM"
Please help me with this, i need to COPY the date in mm/dd/yyyy:hh:mm:ss
 
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.