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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Does excel have text effects?08 Jul 2007 02:51 GMT2
I know that text effects can be used in Word documents. For example, you can
get any text to blink on and off.  I want to know if you can do the same
thing in an Excel spreadsheet.
invisible color08 Jul 2007 01:45 GMT3
I can only see blk/white on my worksheets.  I can change text color and/or
highlight a cell and it appears as though nothing happened.  But - when I
pull up the 'preview' ... the colors show and the colors print correctly.
I want to use the highlight to mark cells that will be ...
I'm still confused08 Jul 2007 01:28 GMT4
I know some have helped on this before, but I cant seem to get it right.  
Heres what I have
A      Name         Age            Time         Score
B        Bob            8                12.2          56
How to calculate bond value and current yield07 Jul 2007 23:32 GMT2
A bond has a $1,000 par value, 12% coupon rate, interest on the bond is paid
annually, the current yield to maturity on the bond is 6%, and the maturity
of the bond is 10 years.
I'm having problems with the formula to compute the following:
Relative Cell References When Linking07 Jul 2007 23:14 GMT2
I have a very large master spreadsheet with links to data in 5 other
spreadsheets.  How can I avoid linking the cells one by one (from the master
to each of the 5), as I have noticed that copying a link formula does not
automatically update the cell reference? I am looking to ...
#name error07 Jul 2007 22:52 GMT3
c10 = 40; d10 can be any number above or below 40. The formula I am using is
supposed to either read the number above or below 40 and read either # over
or # under, depending on which it is. For example, if c10=40 and d10=39.25
then e10 should read .75 under. If c10 and d10 are ...
Insert Row "Missing" from my list07 Jul 2007 21:35 GMT8
I created a list in a worksheet that I have spent hours putting together. It
has been working perfectly for weeks, until now! For some reason the INSERT
ROW at the bottom of the list doesn't appear any more. I have tried several
ways to get around this, including unsorting all of ...
IF function results not displayed in cell07 Jul 2007 19:55 GMT1
I've added a correctly formatted IF statement to a Text cell in a worksheet
(Excel 2003), but instead of showing the result, it shows the formula in the
cell.
I've tried the Ctrl `  key combo - that doesn't help.
count if on Visible - Filtered07 Jul 2007 19:34 GMT4
Hi,
I'm trying to get a simple conditional formula to work when I Auto Filter.
How can this be done?
I need to calculate the percentage of visible cells that have 1 in them of
personal.xls07 Jul 2007 19:32 GMT15
I want to get rid of personal.xls.  I don't need the macro.  Personal is not
hidden but I cannot get to it.  I went into XLStartup, not there either.
I noticed a posting from 2004 said "delete it."  I wish I could.
Pat from southern California.
Formula HELP07 Jul 2007 18:22 GMT3
I want a specific formula to read as:  "if CELL1 is less than CELL2 then...
CELL1+2*(3.25)" or if CELL2 is less than CELL1 then...CELL2+2*(3.25)"  I have
no idea how to use this function or how to type it in. Can anyone help me?
Array Formula and 2 Tabs!07 Jul 2007 16:22 GMT14
I have 2 distinct tabs on my spreadsheet. One called "New Rules Sample", and
the other called "QA Data Sheet". I'm trying to capture all of my relevant
data on the QA Data tab, and so far so good. I have a variety of information
there. However, when I attempted to capture the 2 ...
please help with formula for same cells in different sheets07 Jul 2007 12:11 GMT7
Please can some one help me,
I am trying to get a quick way of coping a formula without having to manualy
change the sheet name.
example:
CREATE DATA FORM FOR DEPENDANT DROPDOWN LIST IN EXCEL07 Jul 2007 11:52 GMT5
I need to enter data in rows under around 5 column headings
Column A has a dropdown list covering around 6 items .- Each of these 6
items have 2 to 3 dependent items coming under and then these dependent items
under column B have around  3 to 4 dependent items under column C - etc ...
Vlookup problem in lookup range07 Jul 2007 10:00 GMT2
i tried to lookup some values but i am getting problems in particular No.
In B1 if i type 23 in B2 it has to lookup value from table and give result
as 12 but its not getting that value this problem is only for 23, 33, 73 for
other values its picking up correct nos. why this is ...
 
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.