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 / General Excel Questions / March 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Trying to do a formula in Excel until the value is 027 Mar 2008 09:07 GMT5
I am trying to do the following formula in Excel:
=IF(D224=0,E223+B224,E223-D224)
I want to do this until the value of Column E = 0, if it does I want
it to display "Current"
Date formula27 Mar 2008 08:04 GMT3
I need a formula that will determine if dates ( formatted xx/xx/xx)in column
B & C are = or greater than 1 year apart and if so to return value "Yes", if
not return value "No".  
Thank you!
I need help writing a complex equation.27 Mar 2008 05:19 GMT7
I have three columns that I want to draw data from combine it into a single
line of data in another columns. So here’s the scenario.
Column 1 has an employee # there’s two designations 01XXXX and 02XXXX.
This is important. More on the importance of that later.
Conditional Formatting27 Mar 2008 05:13 GMT2
Okay. I am needing to have a cells A, if the date entered is less than 90
days to be one color, and if it is greater than 90 days to be one color.
Please help.
OR Nesting?27 Mar 2008 04:52 GMT2
I'm trying to sum column B (minutes) that have different decriptions in
column A.  I want to sum only those descriptions that have the abbreviation
of "PRJ" in them.  Do I need to list out the entire descriptions somewhere
else?
Formula not updating27 Mar 2008 03:36 GMT3
I am using very basic formula to calculate sums on a spreadsheet, and usually
it works fine, but for some reason they are no longer updating? Does anyone
know why? The formula still seems to be in the cell, but it doesn't change
when I amend the numbers above it.
Information copying from sheet 1 to sheet 227 Mar 2008 03:02 GMT1
Stupid Question.
I set up a file with 5 worksheets in it for daily data entry and print.  But
when i enter information in worksheet one it automatically get added to
sheets 2, 3, 4 and 5.  How do I stop it?
#Ref! error using INDIRECT for file name27 Mar 2008 02:03 GMT3
I'm having trouble with the following formula  
=INDIRECT("'S:\14 Finance\SALES\07-08\[Week "&$B41&" 07-08.xls]Summary'!d118")
where $b41 refers to a cell with a week number in it.  When ever I open this
file it returns a #Ref! error unless I open this particular file references
Need a formula to average every other value in a column.27 Mar 2008 02:01 GMT3
I have columns with 100+ values.  I need averages of the odd numbered rows
and then averages of the even numbered rows.  Any ideas?
can't save in excel-pleeeeeeease HELP!!27 Mar 2008 01:56 GMT4
I can't save or save as in excel.  Options are not highlighted.  I used to be
able to and I can on another computer using the same version.  How do I
change this?
Hide Pivot Table Filters27 Mar 2008 01:15 GMT1
I've created a Pivot Table that uses filters in Excel 2007.
Unfortunately, the filters show up above my actual PivotTable on the
spreadsheet itself.  Is there a way for me to prevent these from
showing up while still filtering my data?
what is the formula in excel for higher level of square roots27 Mar 2008 00:40 GMT4
the formula for squre roots in excel is SQRT(number) but what is the formula
for higher level of roots?
SHIFT G27 Mar 2008 00:19 GMT2
I have suddenly a problem on my hands. Whenever I press SHIFT + "G" the
program search for data. This is very irritating as I write a lot of names
(beginning with capital letters) in a excel sheet. How can I stop this
"service" ??
Insert files (pdf, word doc) in excel cell27 Mar 2008 00:03 GMT1
I would like to do a MS Word mail merge using excel as the data source
for a fax blast.  However, I need to send a specific page to a
specific fax number.  I was thinking of setting up an excel document
with [name, fax number, document] columns as the data source, and then
Exponential formula27 Mar 2008 00:00 GMT2
How do I raise a number to a value; e.g., cube, fourth . . . sevententh?
 
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.