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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Can Excel create a conditional Comment on a cell?16 Feb 2007 17:05 GMT4
Can Excel create a conditional Comment on a cell? i.e. if cell value is above
a value, create a comment ("Value is Very High = 'Cell Value' ")
IF statement16 Feb 2007 15:31 GMT3
Hi I would like to know if it is possible to run an IF statement and if the
condition is FALSE. It will leave the value that was previously in the cell?
Thanks in advance
Message pop up16 Feb 2007 15:22 GMT1
I have a list where they can select complete, partial or no. If they select
partial or no I want them to fill in some narrative to explain why in the
next cell - is there anyway of getting a message or something to show this
when they select either of these options so it is ...
RE cell wont update with new link16 Feb 2007 15:13 GMT1
Maybe this is simple but I have a link in a cell A1 on sheet2! which
refers to sheet1! A1
When I goto manually change this link by typing the link in and press
enter it wont take in the cell. the formula shows.
Is it possible run code when a cell is doubleclicked?16 Feb 2007 14:26 GMT2
Is it possible run code when a cell is doubleclicked?
Will excel generate one-tailed confidence intervals for Poisson distribution?16 Feb 2007 13:17 GMT17
OK, I understand why it makes more sense to use the normal distribution, on
our hundreds of thousands of records, but my boss is not convinced - mabye
because he knows the Poisson distribution is skewed to the left, and he said
something about getting higher probabilities than ...
Text question comes up even if cell is blank16 Feb 2007 13:02 GMT2
I have in G43 the following formula which counts all variations of the
word bank, Bank,Banking,Banked,banked well it seems to work.
it does count them.
=COUNTIF(G$5:G$40,"*bank*")
Chart format question16 Feb 2007 12:55 GMT1
I am gathering some research data and putting it into charts.  My prof wants
me to put some data above the bars on the graph.  I think their called
needles.  They are small T looking extentions above the bars that have data
attached to them, like standard deviations.  Perhaps ...
function used to get 30% of sale of $5000.0016 Feb 2007 11:27 GMT2
I'm taking a class in excel 2003. One of the quiz questions is:
B3 cost of sales equals 30% of sales. Create a formula in cell B7 to
calculate the cost of sales for January. Use an absolute reference to cellB3
in the formula.
create a macro to search an excel spread for duplicates16 Feb 2007 10:58 GMT4
I have a 55k line item spreadsheet and want to search thru it to find
duplicate seriel #'s and once found populate a new spreadsheet with only the
duplicates.
calculate a part of a worksheet16 Feb 2007 10:22 GMT2
I have one calculation the creates a random number. I have another
calculation that compares an input number to the random number. The problem
is that when the spreadsheet is calculated the random number changes and is
therefore always different from the input number. Is there a ...
Help!!!  End of Month Calculation16 Feb 2007 09:07 GMT4
I need some help.  I am writing a formula to calculate my asset depreciation
schedule.  The rule is, the new purchased asset will be depreciated for the
full in current month, no matter what date the asset purchased within the
month, the depreciation will be calculated for full ...
V lookup and H lookup together16 Feb 2007 08:57 GMT4
Is it possible to do a v lookup and an h lookup at the same time?  For
example I want to find the data that matches the row and column of the cell
I'm in?
I WANT TO COUNT HOW MANY TIMES A CERTAIN LETTER APPEARS IN A ROW16 Feb 2007 08:39 GMT13
I am trying to figure out sales from an existing spreadsheet.  The
spreadsheet containes packages (A-V) sold.  Each cell may contain more than
one of each letter so I can't just use the CountA function because that only
counts the cell.  I need something to actually count the ...
day and time concatenate16 Feb 2007 06:19 GMT4
I have days stored in a column, and dates associated to them in other. Whe I
try to concatenate them in a single cell, the numbers are converted and I get
something like this:
day                 time           concatenate
 
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.