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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Função Logaritimica10 Sep 2007 19:51 GMT2
Gostaria de saber como o excel calcula os valores que ele apresenta em uma
função logaritimica. Por exemplo na equação y = -2.5279Ln(x) + 11.299.  Como
posso calcular os valores -2.5279 e 11.299 baseado nos valores de X (0.3,
1.0, 3.0, 10.7, 32) e Y (15.26, 12.26, 5.57, 4.74 , 4 ...
Can not access small cross to pull-down data10 Sep 2007 18:04 GMT2
I can no longer use the small cross in the corner of a cell to pull down
formulas or dates.  I must have somehow changed this feature.
Please help.
Thank you
Count number of sheets10 Sep 2007 17:22 GMT5
Hi. I want to create a macro that will count the number of sheets in a
particular workbook. Is this possible?
"freeze" an imported realtime updated cell value10 Sep 2007 16:58 GMT6
how can I "freeze" a given value of a cell which is updated on a realtime
basis, e.g., stock options prices imported from a sort of Bloomberg data
diffusion service? I have a worksheet that evaluates options strategies for
10 options series calculating implied volatility on a ...
COUNTIF10 Sep 2007 16:15 GMT6
if I want to count the number of rown where B4:B65535 > 31/07/06 and <
01/08/07 and C4:C65535 = "No" how would I express this please
Thanks
A
IF Function Help10 Sep 2007 15:34 GMT5
I am creating an Excel spreadsheet to track permit holders.  I need to assign
user IDs to the first three letters of the last name of the permit holders.  
The column for the permit holder's name is column J.  In column I, I need a
formula to take the first three letters of the ...
IF formula10 Sep 2007 15:17 GMT6
I've created a drop down list of companies and I want a formula that will
display the relevant details (entered over a number of cells) when I select
one of them. I've been using the below formula which I know is incorrect but
might give you an idea of what im trying to do:
IF Function10 Sep 2007 14:56 GMT3
I am trying to creat a worksheet to automatically calculate our football
picks.  So far, I have our teams listed in the first column, each in their
own row (A3 - Indy, A4 - New Orleans).  B3 would be the winner (Indy) Column
C - is the person's pick (C3 = 0, C4 = 6)
Excel formula question10 Sep 2007 13:14 GMT2
I am trying to figure out a new formula.  I am trying to create a maintenance
chart.  There are services due on an engine at 12, 24 and 50 hours.  I want
to be able to input the time used on the engine and have all the service
marks count down until they hit zero or a negative ...
fill color not working in excel 200710 Sep 2007 12:56 GMT3
I just put office 2007 on my new laptop for work.  I opened an old excel file
created with excel 2003 and noticed my fill colors weren't in the cells I had
put them in.  I tried to add fill color.  Nothing.  I even tried to create a
new worksheet and entered info in a cell, tried ...
Simple IF statement10 Sep 2007 12:32 GMT4
I need to get a formula which says if there is any value in a2, then
make a1 = "Accepted"
Im sure I need an If statement, but not sure how I do the "any value"
bit.
Page Break Save10 Sep 2007 12:10 GMT1
Hi. Is it possible to save each page in the page break view in a new
workbook?
How do I update a checkbox as true when another has been updated10 Sep 2007 11:06 GMT1
I have a series of checkboxes but some are dependant on previous responses.
I want to update a checkbox with a true response if one previous has been
selected.
Can anyone assist - in simpler terms if possible.
Insert rows without effecting formulas10 Sep 2007 08:53 GMT1
Column A contains employee numbers, column B contains numbers that
correspond to each employee.
In column C are numbers that come from another source and should match
up to those numbers in column B.  In column D is the formula B-D.  All
Formula to Insert Rows10 Sep 2007 08:22 GMT3
I have scanned the posts and could not find the answer to my question.  I
want to be able to insert an entire row when a new client is added.  For
instance
if cell A1 is Jane Smith
 
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.