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 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
7 day workweek timesheet - excluding lunch08 Sep 2006 23:26 GMT3
I thought I alreayd posted this but don't see it anywhere, so forgive me if
this is duplicated somewhere.
I am looking for a formula to calculate total hours worked, to exclude
lunch, based on the assumption of a 30 min lunch if working 6 hours or more
Tax Status08 Sep 2006 23:00 GMT2
I am trying to set up an employee on the work sheet. I do not know what to
type under the Tax Status column. Please help
Forumla Error08 Sep 2006 22:51 GMT5
Can't seem to get this code to work correctly...
=VLOOKUP(Weekly Data'! COUNTIF(M2:M256,"W*")
Any help would be appreciated.
Rob
to get the same answer from a normal calculator08 Sep 2006 22:22 GMT1
I am sales executive for a bank in UAE.My product is Personal
Loan. I am normally using the Ms Excel worksheet to calculate the monthly
installment for my clients.      
            Sometimes,i have to use my calculator to get the installment.
formula won't calculate unless I click cell08 Sep 2006 21:50 GMT2
I am using a countif function in MS Excel. It is counting the instances that
a particular date/ time occurs in a list. The function references the
criteria in an adjacent cell as follows
In cell A2:
Problems with find/replace function08 Sep 2006 21:42 GMT1
I have 25 lines of information that have the word "steel" in the
formula.  When I do a find "steel" and replace with "steel div" it only
replaces the first 15 lines.  The remaining lines I get an error
message that says "That name is not valid".
Looking up the most recent date08 Sep 2006 20:46 GMT3
I have a Database in which I keep track of all the toner for my company. I
list each box as it arrives with a number, and record it (1,2,3...345,346,
etc.). When it arrives, I record the date in one column, when I install it in
a machine, I record that date in the next column, ...
How do I change the appearance of a hyperlink?08 Sep 2006 20:44 GMT1
I am trying to change the appearance of a hyperlink into a button or a
graphic.  How do I do this?  (I have the hyperlink in my spreadsheet, but I
can't get it to insert into a button)  What should I do?
printing worksheet in newspaper columns08 Sep 2006 20:39 GMT1
I have a long list (3 columns wide) and I would like to print in a column
set-up (similar to word).  Does anyone know how to do this or if it can be
done?
Linking Jpeg Images to excel.08 Sep 2006 20:33 GMT1
Odd question, but I have a file with about 160 images and would like to
link them to an excel file under category tabs example;
People, Nature, Technology etc.
There are 21 main files and within them about 2 - 4 sub files each.
How do I create "push buttons" in Excel?08 Sep 2006 20:32 GMT2
I am trying to create push buttons in Excel.  (Hyperlinks, maybe?)  It is a
button that can be pushed to direct the user to a different worksheet in the
same file.
dannycol08 Sep 2006 20:29 GMT5
I would like a macro which will format a selected range of cells to have
capital letters.. any help would be appreciated
to get the same answer from a normal calculator08 Sep 2006 20:23 GMT1
I am sales executive for a bank in UAE.My product is Personal
Loan. I am normally using the Ms Excel worksheet to calculate the monthly
installment for my clients.      
            Sometimes,i have to use my calculator to get the installment.
I recorded a macro, how can i share it with others?08 Sep 2006 20:09 GMT1
Can I email a recored macro?
What is Wrong with this function??????????08 Sep 2006 19:47 GMT2
=IF(AND(Z17>0,Z17<=12),Z17+12,Z17,IF(AA17<=7,".00",IF(AA17<=22,0.25,IF(AA17<=37,0.5,IF(AA17<=52,0.75,IF(AA17<60,".00"))))))
For the Love I cannot find the problem. Excel says there are too many
arguments for the function.
Someone please please please Help.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.