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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Nested IF statements - maxed out!23 Jun 2007 00:59 GMT2
I currently have the following formula in a cell:  
IF(AND(J40=12,J41="YES"),"Multiple",IF(J39="","",IF(AND(B48="NO",J40=6),SUM(B39,B41,B43)*3,IF(B48="YES",SUM(B49:B52,B41,B43,B43,B45),IF(AND(B46="YES",D54="YES"),(((+B39+B41+B43)*2)+B45),IF(B46="YES",(((+B39+B41+B43)*4)+B45) ...
Highlighting cells - Mouse sticking??23 Jun 2007 00:46 GMT2
When I am in Excel the mouse appears to be sticking and highlighting all
cells as if I am holding down the shift key. The keyboard does not work
either. Thinking that it could be a mouse or keyboard problem I logged into
another user and it works fine. I have to log off Excel ...
SUMIF Function Problem22 Jun 2007 23:24 GMT3
So far I've got the formula working and it looks like this:
=SUMIF($B$1:$B$9639,"<=33",$C$1:$C$9639)
The problem is that I have to manually enter the "33", or whatever number I
need to be less or equal to, even though it is sitting in a cell just a few
Averaging times (similar to lap times)22 Jun 2007 23:15 GMT1
Hello, I have some dates like this:
1:54.334
1:54.442
1:54.553
sum of a column22 Jun 2007 22:46 GMT4
Hi guys, I am in need of a wee hand.
I have 2 columns, C & D.
C is a weekly column where an amount is placed for example 150.
D is the difference between each week. i.e C3 and C4 , C4 and C5 and so on.
Using conditional formating to copy range of cells22 Jun 2007 22:31 GMT1
i understand condition formating:
=if(a1=1, "one", "wrong")
but this is what i'm trying to do:
=if(a1=1, [copy the range of cells of a12:a14], "wrong")
switch from one worksheet to another without using mouse22 Jun 2007 22:26 GMT2
How can I switch from one worksheet to another within the same workbook
without clicking on it?
change straight quotes to curly quotes22 Jun 2007 22:23 GMT2
Hi there Excel experts!
Is there anyway to make Excel use curly quotes instead of straight quotes?
I know it's doable in Word, Powerpoint and a few other MS products but I
haven't seen this option on Excel.
tab key22 Jun 2007 22:20 GMT1
Is there a way to set how the tab key moves the curser to the next position?  
I would like to be able to be able to designate the next input area to go to
when the tab key is pressed.  This would allow me to go up, down, forwards or
backwards through the worksheet.  I am thinking ...
Generating Unique Sequential Numbers22 Jun 2007 22:12 GMT3
I am trying to create a form which will generate a sequential number by
clicking on a command button - one of the example templates in excel seems to
do this by using a macro, but I have no idea how to do this - can anyone help?
Change Default Template22 Jun 2007 22:02 GMT1
My Paper Size keeps changing back to A1 from A4.
I would like to remove the default template and start again.
I have done a search for Book.xlt but just can't find it.
Please help
How to rotate a list of numbers?22 Jun 2007 21:54 GMT4
There is a list of numbers under column A, and I would like to rotate this
list from vertical into horizontal axis, such as
A1 to A1
A2 to B1
microsoft excel has not been installed for current user22 Jun 2007 21:46 GMT2
my microsoft office 2003 is not working any more after update for windows
from internet when i try to open excel word or other office application it
gives me the microsoft excel is not installed for current user pls run set up
for installation although the program is installed so ...
The title bar22 Jun 2007 21:43 GMT2
  I have a microsoft excel project that has the title "Customer
Support",but it appears in the upper part of the page "the blue one" as
"Microsoft Excel - Customer Support".
 Is there a way to erase the word "Microsoft Excel" ?
Hyperlinks work once, then break22 Jun 2007 21:20 GMT3
Excel 2003 on Win XP
A grid has been created to allow users to find the info they need (titles
typed into Excel cells) then jump to the appropriate resource (web page,
file, etc) by clicking on a link in the next column/cell. There are two
 
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.